|Posted by:||Manuel Murieta (livelong…@gmail.com)|
|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.