Name sheet tab by today's two digit date

  • Thread starter Thread starter Annette
  • Start date Start date
A

Annette

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
 
activesheet.name = Format(Date,"dd")

demo'd from the immediate window:

activesheet.name = Format(Date,"dd")
? activesheet.name
02
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference sheets named by DAY 7
Combine two spreadsheets into one 3
Main Sheet 6
Excel Monthly Spread sheet. 12
Excel How to get the number of days an item was opened from the today's date. 14
Linking Worksheets 1
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Add new sheet automatically every data. 1

Back
Top