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)

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)