Unwanted recalculation of UDF while running a Replace-statement
Hi all,
I'm running a macro with under a 'Application.Calculation = xlManual' -state. Part of my macro is the .Replace statement. Is there a way to prevent a User Defined Function (UDF) from recalculating while running this .Replace statement? This replacement doesn't affect the UDF values and calculating takes a long time. FYI, this UDF doesn't have the Application.Volatile statement. Thanks in advance for any feedback! - Jim |
All times are GMT +1. The time now is 02:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com