View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul Paul is offline
external usenet poster
 
Posts: 661
Default macro to: Add new sheet, then rename new sheet with todays dat

Indeed !! that works, a large Thanks !
"Paul B" wrote:

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 !