VBA to change sheet name to TODAY()??

[thelostscott]

Hi all,

Is there any way to have in code Sheet1 renamed to TODAY() whenever the code is run?

Cheers!

 

[VoG]

Try like this

Sub test()
Sheet1.Name = Format(Date, "ddmmyy")
End Sub

 

[RoryA]

Something like:

sheet1.name = format(date, "dd-mm-yyyy")

 

[thelostscott]

Works great, thanks!