i've recorded a macro that creates a new sheet. but how do i get the new sheet's tab name to be todays date. For example if i create a new sheet tomorrow the i want the tab to be named 09/04/2008 or something similar.
![]()
Sub newsheet() ' ' newsheet Macro ' Macro recorded 08/04/2008 by JSmith3 ' ' Sheets("Template").Select Sheets("Template").Copy Before:=Sheets(1) Range("L21").Select End Sub
Bookmarks