Name Tab With Date

  • Thread starter Thread starter Blue
  • Start date Start date
B

Blue

I have code to add a new sheet to a workbook but I want to name the tab
with today's date as the new sheet is created in the format DD-MMM

Thanks Blue
 
Try this:

activeworkbook.sheets.add
activesheet.name = format(Now, "dd-mmm")
 
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

Delete sheets code error requires object 2
Save each sheet of multi-sheet workbook as a single-sheet workbook 3
Re-format Date 2
Date format. 1
Excel is changing date format incorrectly 7
Date formats change (code included) 9
Formatting variable problem 2
problem formatting a variable 1

Back
Top