Posted to microsoft.public.excel.programming

Nigel[_7_] Nigel[_7_] is offline

external usenet poster

Posts: 14

Creating non-volatile Date

Hi All
I have a requirement to, from within VBA, store the
current date into a worksheet.cell. But for that date to
be non-volatile.

If I use the system date functions then this will always
change, after the worksheet is reloaded. What is the best
approach to overcome this?

Cheers
Nigel

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
Volatile Symbol	DOUG	Excel Discussion (Misc queries)	4	April 21st 09 03:28 PM
How do I make DATE non-volatile?	MichaelRobert	Excel Worksheet Functions	3	June 21st 08 04:23 PM
INDEX - volatile or not?	T. Valko	Excel Worksheet Functions	8	February 23rd 07 07:24 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 12:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us