Date on W/sheet Tab!

[mellowe]

Hi All

Is it possible to use VB code to re-name a worksheet tab with todays
date?

Say the w/sheet was called Core1 and after a macro has been run it
needs to rename Core1 to todays date is that possible?

thnx

 

[Mark Lincoln]

Sub ChangeSheetName()
Sheets("Corel").Name = Format(Date, "mm-dd-yy")
End Sub

Change the format to match how you want the date displayed. (Don't use
forward slashes.)

 

[mellowe]

Brilliant worked perfect thanks!!!

 

[Guest]

ActiveSheet.Name = Month(Now) & "." & Day(Now) & "." & Year(Now)