Interrupt find and replace

R

Richard

When using the find and replace feature for an entire sheet, does anyone know
if there is a way to interrupt the process? I made a mistake in the replace
value and now I have to either crash my excel or hit the "ESC" key after
Excel attempts to replace each entry.
 
J

Jerry W. Lewis

AFAIK your only other option is to kill the Excel session (assuming that
you have saved recently enough for this to be a time savings). This
extremely unfriendly aspect of the interface has been pointed out to the
design team by more than one MVP. Perhaps a future version will handle
the situation more gracefully.

Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

WORD VBA Search and switch to advanced ... 1
Can't save my Office documents (after computer rebuild and reauthorization) 0
Problem with Upload Center on Office 2010 when using encrypted area on disk 0
VBA: Macro to find and replace multiple instances of text with form field 0
How do I find/replace data in selected cells only 5
Find and Replace 0
Replace 1
Need help modifying code 0

Top