How do I get my code to run only for Column E. Right now it is running for the entire worksheet. How do I set the focus for Column E.
Sub ChgStatus() Sheets(1).Columns("E").Replace What:="Pending", Replacement:="Done", _ LookAt:=xlPart, MatchCase:=False End Sub
Click Here Before Posting Data or VBA Code —> How To Post Data or Code.
This should work.
Click Here Before Posting Data or VBA Code —> How To Post Data or Code.