Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically naming a worksheet tab with dates?
Mark
You can certainly do this with a macro, if that's what you are asking. If the sheets already exist, then Dim i as Long For i = 1 to 30 Worksheets(i).Name = Format(DateValue("11/" & i & "/2003"),"dddd dd mmmm") Next i -- Dick Kusleika MVP - Excel www.dicks-clicks.com "Mark" wrote in message ... In a workbook, I am trying to create a worksheet for each day of the month of November. Is there an automatic way of naming a series of worksheet tabs in a consecutive format. From my knowledge I have to name each work sheet manually with the dates. Example Tuesday 11 November Wednesday 12 November Thursday 13 November Mark. 8) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically naming a worksheet tab with dates?
Is this the visual basic language that I need to enter into the macro
editor? "Dick Kusleika" wrote in message ... Mark You can certainly do this with a macro, if that's what you are asking. If the sheets already exist, then Dim i as Long For i = 1 to 30 Worksheets(i).Name = Format(DateValue("11/" & i & "/2003"),"dddd dd mmmm") Next i -- Dick Kusleika MVP - Excel www.dicks-clicks.com "Mark" wrote in message ... In a workbook, I am trying to create a worksheet for each day of the month of November. Is there an automatic way of naming a series of worksheet tabs in a consecutive format. From my knowledge I have to name each work sheet manually with the dates. Example Tuesday 11 November Wednesday 12 November Thursday 13 November Mark. 8) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet naming | Excel Discussion (Misc queries) | |||
Automatically naming and linking controls | Excel Worksheet Functions | |||
Stop 2007 automatically naming ranges | Excel Discussion (Misc queries) | |||
Naming Worksheet | New Users to Excel | |||
Automatically naming a tab | Excel Discussion (Misc queries) |