LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Named Ranges Epinn Excel Worksheet Functions 23 October 16th 06 07:27 AM
Mileage Claim Formula johndavies New Users to Excel 4 August 14th 06 09:24 AM
insert date Larry Excel Worksheet Functions 28 July 15th 06 02:41 AM
search for latest date Sue Excel Worksheet Functions 2 August 2nd 05 11:09 PM
Does excel recognise names rather than cells? Sue Excel Worksheet Functions 9 May 22nd 05 04:51 AM


All times are GMT +1. The time now is 05:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"