Posted to microsoft.public.excel.programming

[email protected] Spencer.Sadkin@gmail.com is offline

external usenet poster

Posts: 42

volatile

I have a function that i need to be volatile, but when i run a short
macro that usually takes about 30 seconds with this function as
volatile it takes a long time to run ( i have never bothered even
letting it complete). I wanted to do boolean logic and an if then but
this doesnt seem to work any ideas on how to have a function not
recalculate when a macro is running but recalculate when it is not?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
volatile v non-volatile	CJ	Excel Discussion (Misc queries)	4	February 12th 10 12:16 PM
INDEX - volatile or not?	T. Valko	Excel Worksheet Functions	8	February 23rd 07 07:24 PM
Application.Volatile	Nader	Excel Programming	3	June 9th 06 04:14 PM
Need for Application.Volatile?	Paul Lautman	Excel Programming	2	August 19th 04 10:43 PM
Detect any Volatile UDF	Sandy V[_4_]	Excel Programming	4	October 23rd 03 01:26 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us