Name sheet tab by today's two digit date
 

How can I programmically name a sheet by today's date? I have a user that
has to process daily incoming spreadsheet and she attaches to a monthly
sheets and I thought it would be easier for her if she had a macro to run
the sheet name change.

Thanks!

Annette

Name sheet tab by today's two digit date
 

activesheet.name = Format(Date,"dd")

demo'd from the immediate window:

activesheet.name = Format(Date,"dd")
? activesheet.name
02


--
Regards,
Tom Ogilvy

"Annette" wrote in message
...
How can I programmically name a sheet by today's date? I have a user that
has to process daily incoming spreadsheet and she attaches to a monthly
sheets and I thought it would be easier for her if she had a macro to run
the sheet name change.

Thanks!

Annette