Find/Replace on Range?

  • Thread starter Thread starter Al Franz
  • Start date Start date
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.
 
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
 
Back
Top