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