xl2000 US English, Windows 2K

? Format(Now,"MM/DD/YY")
06/03/04

I have never experienced a problem with that in xl2000 or xl97.

The problem might be a bad reference.

--
Regards,
Tom Ogilvy

"kkknie " wrote in message
...
With each new version, a lot of new functionallity gets added to Excel
VBA. If you took advantage of this in a new version and then try to
run it in an old version, you're out of luck. You will either need to
recode for the old version or require them to run in the new version.

One example I struggle with is Format(Now,"MM/DD/YY") which works great
in 2002 VBA, but hangs in 2000 VBA.

K


---
Message posted from http://www.ExcelForum.com/