View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Publius Publius is offline
external usenet poster
 
Posts: 3
Default Rename sheet with NOW date

I have a macro recorded that creates a new worksheet (each day) and it will
allow me to rename the new sheet, but I cannot figure out how to make it put
the date "NOW" in as the new worksheet's name and leave it named that date
forever. Can anyone tell me how to do it?