Naming a sheet by a date
Posted by rob on January 23, 2002 2:18 AM
I want to name a sheet using the Date function i.e.
Sheets(lastSheetName + 1).Name = Date
But the default for date in my regional setting is dd/mm/yyyy so the / character won't go into the sheet name. Is there a way I could convert the date into a string so the it came up as dd_mm_yyyy? I know I can just change the regional setting but this needs to be used on more then one computer. Thanks for help in advance.