Macro help - add column selection

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
 
J

Jackpot

Try the below..No need to select

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tidy up multiple find and replace code 2
Using Popups to supply variables 6
Change a great number of words in word files, with a macro as short as possible. 5
Standardizing Addresses Help 6
find and replace multiple values in one statement 3
Macro Not Changing Date Values 7
Edit REplace String 2
Find and Replace is going wrong in some cases 10

Top