Rename Cell VBA

[blimes]

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

 

[DanteAmor]

How about:

Sub test()
  Range("X:X,CE:CE,CU:CU,DW:DW,DG:DG").Replace What:="JJ Redick", Replacement:="J.J. Redick", _
    LookAt:=xlWhole, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
    ReplaceFormat:=False
End Sub