ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Any way to know in SheetChange event that Find/Replace was invoked? (https://www.excelbanter.com/excel-programming/355728-any-way-know-sheetchange-event-find-replace-invoked.html)

[email protected]

Any way to know in SheetChange event that Find/Replace was invoked?
 
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



All times are GMT +1. The time now is 05:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com