thanks very much Rowan

I'll give it a try

cheers

Kathryn


"Rowan" wrote:

I don't think there is a way to have Excel do this as part of the standard
functionality. You could do it with a macro though:

Sub nmsht()
Dim i As Integer
On Error Resume Next
For i = 1 To 12
Sheets(i).Name = MonthName(i)
Next i
On Error GoTo 0
End Sub

Regards
Rowan

"Kathryn W" wrote:

hi there

I want to auto name my worksheets in Excel. Eg: Name the first shet January,
nrext sheet February, then have Excel auto name the remaining ten sheets with
the remaining months of the year.

This is similar to the auto fill function where cells can be filled
automatically, but I cannot work out how to name worksheets this way.

Does anyone know if this can be done, and if so, how?

thanks

Kathryn