vzachin
02-27-2007, 12:51 PM
Hi
How can I write a code to save a sheetname with today's date formatted ddmmyyyy?
I tried the following:
Range("A3").Formula = "=TODAY()"
Sheets("2").Name = Range("A3")
but it's giving me an error message because of the slashes in the dates.
thanks
zach
How can I write a code to save a sheetname with today's date formatted ddmmyyyy?
I tried the following:
Range("A3").Formula = "=TODAY()"
Sheets("2").Name = Range("A3")
but it's giving me an error message because of the slashes in the dates.
thanks
zach