I have two spreadsheets one works one does not. The only difference is
the capital N in Now. Yes, in the line "If dtDate = 0" in both
instances it is a zero.

In the sheet that does NOT work when I type in a capital N and it makes
it lower case. It will not regonize Now as a function and crashes with
a "Compile error: expected Function or variable."

The Sheet that works has this code:

If dtDate = 0 Then
dtDate = Now
End If

The sheet that does not work has this code:

If dtDate = 0 Then
dtDate = now
End If

It's Monday and I am already confused.
Thanks for looking at this...Craigm


--
Craigm
------------------------------------------------------------------------
Craigm's Profile: http://www.excelforum.com/member.php...o&userid=24381
View this thread: http://www.excelforum.com/showthread...hreadid=539850