Macro to Name Current Worksheet

sully2

Board Regular
Joined
Jan 27, 2013
Messages
78
Hello and thank you in advance, I was hoping someone could develop a simple code for me that would name the current Worksheet something like -
"Today's Date (30-09-14) Run Sheet"

Cheers!
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Try

Code:
Sub test()
ActiveSheet.Name = Format(Date, "dd-mm-yy") & " Run Sheet"
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,108,954
Messages
5,525,880
Members
409,669
Latest member
JDCupps

This Week's Hot Topics

Top