Unwanted recalculation of UDF while running a Replace-statement

J

Jim

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
 

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

Can't Prevent Recalculation 4
Find Text, Replace Text and Bold It in a Macro 10
Optimizing a macro for speed- find and replace 3
prevent recalculation of random data except in a "Calculate" macro 2
Calculating a range in VB Excel XP 1
Can I improve processing speed of macro 4
Minimize Excel When Running a Macro 1
Not Enough Memory - While Running a Macro 0

Top