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 !
|