Posted to microsoft.public.excel.programming

external usenet poster

Posts: 4

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do you find and replace unwanted symbols in text cells?	cw2r44	Excel Discussion (Misc queries)	2	January 6th 10 06:09 PM
Running list - statement entries	Megoodgal	New Users to Excel	1	July 12th 07 04:28 PM
Is it possible to find which sql statement is running?	nkw	Charts and Charting in Excel	0	September 8th 06 05:56 AM
I want a running balance like a bank statement	Roger Campbell	New Users to Excel	4	January 25th 05 09:15 AM
Type mismatch while running If statement	Stel	Excel Programming	4	December 18th 03 09:19 AM

All times are GMT +1. The time now is 06:28 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us