ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Unwanted recalculation of UDF while running a Replace-statement (https://www.excelbanter.com/excel-programming/404400-unwanted-recalculation-udf-while-running-replace-statement.html)

Jim[_13_]

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