How to stop Excel from doing wrong Find/Replace

W

Wiley

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.
 
N

Nekodvoru

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
 
W

Wiley

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.
 
Top