How to stop Excel from doing wrong Find/Replace
 

Hello,
Is there any solution besides Esc and Ending the program.

Thank you

How to stop Excel from doing wrong Find/Replace
 

Once it stops doing the replace, you can hit ZTRL+Z (or Edit/Undo Replace) to
return to the state before you started the incorrect Replace.

"Nekodvoru" wrote:

Hello,
Is there any solution besides Esc and Ending the program.

Thank you

How to stop Excel from doing wrong Find/Replace
 

Thank you.
Is it possible to write a procedure to automate clicking Esc button-the
problem is I have to many links in files that give Reference error when doing
find/replace

"Wiley" wrote:

Once it stops doing the replace, you can hit ZTRL+Z (or Edit/Undo Replace) to
return to the state before you started the incorrect Replace.

"Nekodvoru" wrote:

Hello,
Is there any solution besides Esc and Ending the program.

Thank you

How to stop Excel from doing wrong Find/Replace
 

Thanks for the feedback. I don't know of a way of using the escape key in a
macro. One way is to jsut do a FInd Next and Replace, rather than ERpalce
ALL?

Can you give an example of how the Find and Replace give you errors?
Perhaps we can help you refine the Find/Replace.

"Nekodvoru" wrote:

Thank you.
Is it possible to write a procedure to automate clicking Esc button-the
problem is I have to many links in files that give Reference error when doing
find/replace

"Wiley" wrote:

Once it stops doing the replace, you can hit ZTRL+Z (or Edit/Undo Replace) to
return to the state before you started the incorrect Replace.

"Nekodvoru" wrote:

Hello,
Is there any solution besides Esc and Ending the program.

Thank you