Dates in Tabs

[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

 

[JMay]

post your code (macro) so that we can see where you are at this point.

 

[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

 

[JMay]

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

 

[Voodoodan]

That's exactly what I wanted.

Thanks very much,
Dan