Renaming sheet

Giganews Newsgroups
Subject: Renaming sheet
Posted by:  Manuel Murieta (livelong…
Date: Fri, 19 Jan 2007

I would like a macro that will rename a sheet to today's date.  I already
have the date set in A1 as val(today()) so that it doesn't change once the
sheet is copied and viewed another day. Now I would like the macro to name
the sheet as the date.  Since the program enters the date as 1/19/07 I have
been renaming the sheet manually as 1-19-07 since the sheet cannot accept
the "/" as part of the name.