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


"HeatherJ" wrote:

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