Macro help - add column selection

  • Thread starter Thread starter HeatherJ
  • Start date Start date
H

HeatherJ

I have the following replace info in a macro.

Selection.Replace What:="Of", Replacement:= _
" of ", LookAt:=xlPart, SearchOrder:=xlByRows, _
MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False

I only want this applied to Column A. What do I need to add so it only does
the replacements in Column A?

Thanks, Heather
 
Try the below..No need to select

Columns(1).Replace What:="Of", Replacement:= _
" of ", LookAt:=xlPart, SearchOrder:=xlByRows
 
Back
Top