SHEET NAMING

[rnkshan]

HOW DO I NAME VARIOUS SHEETS IN MY WORK BOOK WITH DATES OF A MONTH
e.g. FEB 9, FEB 10 ETC
IN ONE SHORT

 

[muddan madhu]

try this

in Sheet1 , Range A1: A10 type FEB 9, FEB 10 and so on

run this macro

Sub sheet_name()
For a = 1 To Sheets.Count
Sheets(a).Name = Cells(a, 1).Value
Next
End Sub

 

[Bob Phillips]

Double-click the sheet tab and over-type the value.

 

[Roger Govier]

Hi

I have written a macro that will produce 12 workbooks with sheets named for
each day within each month.
It can be downloaded from here
http://www.contextures.com/CreateMthlyWkbks.zip