Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
format
Hello all,
I would like to name a worksheet based on "Today()" that is in a text box. I am having trouble because you cannot use "/" ":" etc in a sheet name. All I need is the date and "12-22-04" would work well. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
format
Tim
Not sure if ive understood right, but to create a new sheet, and name as todays date (with your format below), you could try; Sub addsheet() Dim NewSheet Set NewSheet = Sheets.Add NewSheet.Name = Format(Date, "mm-dd-yy") End Sub Dave "Tim" wrote in message ... Hello all, I would like to name a worksheet based on "Today()" that is in a text box. I am having trouble because you cannot use "/" ":" etc in a sheet name. All I need is the date and "12-22-04" would work well. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding time in 24 hour format to produce hours in decimal format | Excel Worksheet Functions | |||
Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
how to format excel format to text format with separator "|" in s. | New Users to Excel | |||
Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work | Excel Programming |