Prev: MEDIANIF
Next: AVERAGEIF Condition
From: HeatherJ on 4 Jun 2010 09:27
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
From: Jackpot on 4 Jun 2010 09:35
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
 | 
Pages: 1
Prev: MEDIANIF
Next: AVERAGEIF Condition