I have the following VBA code in one of my files. If i wanted it to only search in columns x,ce,cu,dw,and dg how could i modify it??? I have hundreds of these entries like this with different names on it so it is slowing my speed down.
Cells.Replace What:="JJ Redick", Replacement:="J.J. Redick", LookAt _
:=xlWhole, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Thanks
Adam
Cells.Replace What:="JJ Redick", Replacement:="J.J. Redick", LookAt _
:=xlWhole, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Thanks
Adam