Find/Replace woes

[William DeLeo]

I am trying to use the Edit/Find/Replace feature to change
the contents of a select range of cells on my sheet. I
select the ranges I'd like to search (and not the ones I
do not want to search), click find, and it correctly finds
all the fields I want to change. BUT when I click REPLACE
ALL, it affects the WHOLE SHEET!! ... the items FOUND
within the range I selected as well as those not listed as
found at all. I have thousands of changes to make so I
cannot just click through and approve every change. What
is going wrong?????

Thanks

 

[Dave Peterson]

When you select your range and do a find All, you'll see that the selection
changed back to the active cell--not the whole multicell range.

So if you do replace with just one cell active, excel figures you mean the whole
worksheet.

So either don't do that intermediate find all or reselect your range after that
find All.

 

[William DeLeo]

You're absolutley brilliant!

Thanks!!

-----Original Message-----
When you select your range and do a find All, you'll see that the selection
changed back to the active cell--not the whole multicell range.

So if you do replace with just one cell active, excel figures you mean the whole
worksheet.

So either don't do that intermediate find all or reselect your range after that
find All.



--

Dave Peterson
(e-mail address removed)
.