View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul B[_3_] Paul B[_3_] is offline
external usenet poster
 
Posts: 14
Default macro to: Add new sheet, then rename new sheet with todays date

Paul, something like this,

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

Paul B
"Paul" wrote in message
...
With workbook already open, would like to have a macro perform:
1) add new sheet
2) rename that new sheet with todays date.

Step 1 easy, completed.
Need guidance on step 2


Thanks !