Excel VBA Range Scope for Find/Replace

[TorontoNewf]

Greetings,

I am interested in doing a Find/Replace on a specific range.
Controlling the scope to Worksheet vs Workbook seems to be my issue.

Doing a regular replace produces inconsistent results:
Selection.Replace _
what:="abc", Replacement:="xxx", _
LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, _
SearchFormat:=False, ReplaceFormat:=False

The WB/WS scope appears to be dependent on the previous Find/Replace
i.e. if I did a WB replace, the next VBA Find/Replace will also be for the entire WB.

How do I change and control the scope?


Thanks,

 

[Fluff]

Put this before your replace code

   Range("A1").Find ("@@@")

 

[TorontoNewf]

Wow; unbelievably simple.

I wasted a lot of time trying to find some re: 'Within:='
You ARE the man!

Muchos gracias!

 

[Fluff]

You're welcome & thanks for the feedback