| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trouble naming worksheet
Dave and Jim,
Thanks. All is well now! "Dave Peterson" wrote: Maybe... ws2.Name = format(ws1.Range("L4").value, "YYYY_MM_DD") or just ws2.Name = format(date, "YYYY_MM_DD") Coal Miner wrote: My code is having trouble assigning a new name to a worksheet. I thought this would work ws2.Name = ws1.Range("L4"). Cell "L4" on ws1 contains the function TODAY(). I thought this would go ahead and assign todays date to the name of ws2. The code breaks and the run time error does mention I cannot use any / \ * etc. in the name. I tried to format the date to something like 3-10-06 but to no avail. What the heck is wrong with this simple request? -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet naming | Excel Discussion (Misc queries) | |||
| Naming Worksheet tabs | Excel Discussion (Misc queries) | |||
| Naming Worksheet | New Users to Excel | |||
| Naming a worksheet help? | Excel Worksheet Functions | |||
| Trouble Naming Range | Excel Programming | |||
Threaded Mode
