Name Tab With Date
 

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

Name Tab With Date
 

one way:

Worksheets.Add.Name = Format(Date, "dd-mmm")

In article ,
"Blue" wrote:

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

Name Tab With Date
 

Try this:

activeworkbook.sheets.add
activesheet.name = format(Now, "dd-mmm")

"Blue" wrote:

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

Name Tab With Date
 

Thanks for the quick replies