I cannot replicate your problem unless I have OptionsWithinWorkbook
selected.

Try with Worksheet selected in Options after selecting a range of cells.


Gord Dibben MS Excel MVP



On Thu, 6 Aug 2009 11:20:06 -0700, Mike_3333
wrote:

I know how to find and replace, the problem, based on the question is that in
older versions of Excel, you could find and replace on "selected" cells. In
2007, it now replaces every occurance of the "Find" in the entire
sheet/workbook. I need to be able to find and replace in just selected cells
NOT the whole worksheet.

"Teethless mama" wrote:

select your range find what: your criteria Replace with: your criteria
Replace All

"Mike_3333" wrote:

I use to be able to find and replace data in "Selected" cells. Now 2007
wants to find replace all in the entire workbook, or sheet.