have find/replace only look in a range

[still learning]

Hi
Can I create a named range and then have find/replace look only in there instead of having it look in the full sheet or what i've highlighted?


mike

 

[rlv01]

If you press the 'F5' key (Go To) and select your named range from the list, Excel will select/highlight that range. Then find/replace should limit itself to the selected range. If that is not what you mean, you will have to explain further.

 

[still learning]

Yep that is what i was looking for
thank you

mikw