Dates in Tabs

V

Voodoodan

Hi!

I have recorded a macro to copy an existing worksheet and add it int
the workbook.

However the new sheet will show, for example, "Test (2)". I'd like th
new tab to show today's date instead.

Does anyone know if this can be done and, if so........... how?!?

Many thanks,
Dan
 
V

Voodoodan

Ok, here it is. Unfortunately, it's just a recorded macro, not reall
rocket science this one!!

Sub CopyTab()
Sheets("Test").Select
Sheets("Test").Copy After:=Sheets(3)
End Sub

That's it!

Thanks,
Dan
 
J

JMay

add this line before End Sub:
ActiveSheet.Name = Format(Date, "yyyy-mm-dd") 'Returns 2004-06-02
HTH
 
Top