Thread: Rename new worksheet with the current date
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_706_] Leith Ross[_706_] is offline
external usenet poster
  
Posts: 1
Default Rename new worksheet with the current date

Hello Jeff,

Once the sheet is copied, it becomes the ActiveSheet. This examples
names the new sheet "31-dec-2008".

Code:
--------------------

ActiveSheet.Copy After:=ActiveSheet
ActiveSheet.Name = Format(Now(), "dd-mmm-yyyy")

--------------------

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.thecodecage.com/forumz/member.php?userid=75
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=45238

Reply With QuoteReply With Quote