View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HeatherJ HeatherJ is offline
external usenet poster
 
Posts: 24
Default Macro help - add column selection

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