Any way to know in SheetChange event that Find/Replace was invoked?

R

roybrew

Is there any way to know that a sheetchange event was invoked from a
Replace All operation from the Replace dialog box? It appears that
Excel "makes the changes" and then does not fire the sheet change
events until after the user answers the "Excel has completed its
replacement and has made x changes" message.

Roy
 

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

Faster way to find and replace? 1
How to know what caused SheetChange event.. 0
Find and Replace in VBA 3
Is there any way to reliably override change tracking actions in Word? 1
Need event macro to tab past a (calculated) cell 4
Multi-select listbox - mousedown event 2
Reset Find/Replace settings? 4
Find/Replace Event or Find/Replace for Protected Sheet ... 2

Top