Find/Replace on Range?

A

Al Franz

When I highlight a column or some cells I can not restrict a FINE and
REPLACE to those highlighted cells. Can this be done so that it doesn't
search the whole sheet? Using Excel 2003.
 
G

Gord Dibben

All

When you select a range of cells and specify "within" Sheet from Options the
Find will take place only in the selected range.

If you specify "within" Workbook the Find will ignore your selected range and
do the workbook.

Same goes for Replace.

Gord Dibben Excel MVP
 

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

Dealing with the error: unable to filter on excel hc home school 0
Custom toolbar button for search and replace 1
Word macro that can call cells out of Excel for a find and replace 0
Need Help with a VBA subroutine 0
Prompt For Replace in Selection And More... 0
Quotation Mark preferences missing 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Dates In Excel 5

Top