If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Macro help - add column selection
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 |
Thread Tools | |
Display Modes | |
|
|