| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing a sheet name to the current date
Hi. I am trying to rename a new sheet to the current date, using the
"15-Mar-06" format, but I keep getting an error whenever I hit this line of code: ActiveSheet.Name = ActiveSheet.Range("H3").Value ....where H3.value is the current date. I think its seeing the "/"s in the date and not wanting to accept the value, even though I have a line above where I change the format of the date in that H3 cell. Name = Date doesn't work either, I think for the same reason. Any ideas? thanks oodles! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing a sheet name to the current date
Try this:
ActiveSheet.Name = Format(ActiveSheet.Range("H3").Value,"dd-mmm-yy") "Reddist" wrote: Hi. I am trying to rename a new sheet to the current date, using the "15-Mar-06" format, but I keep getting an error whenever I hit this line of code: ActiveSheet.Name = ActiveSheet.Range("H3").Value ...where H3.value is the current date. I think its seeing the "/"s in the date and not wanting to accept the value, even though I have a line above where I change the format of the date in that H3 cell. Name = Date doesn't work either, I think for the same reason. Any ideas? thanks oodles! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing a sheet name to the current date
That works perfectly. Thanks!
"Eric White" wrote: Try this: ActiveSheet.Name = Format(ActiveSheet.Range("H3").Value,"dd-mmm-yy") "Reddist" wrote: Hi. I am trying to rename a new sheet to the current date, using the "15-Mar-06" format, but I keep getting an error whenever I hit this line of code: ActiveSheet.Name = ActiveSheet.Range("H3").Value ...where H3.value is the current date. I think its seeing the "/"s in the date and not wanting to accept the value, even though I have a line above where I change the format of the date in that H3 cell. Name = Date doesn't work either, I think for the same reason. Any ideas? thanks oodles! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Current Date on a Sheet 1 Tab | Excel Worksheet Functions | |||
| formula for current date when opening spread sheet | Excel Worksheet Functions | |||
| a Month to Date and Year TD page in one sheet changing each day? | Excel Discussion (Misc queries) | |||
| Can I automatically enter the current date or current time into a | New Users to Excel | |||
| changing current directory to that of the current open file | Excel Programming | |||
Linear Mode
