on your first sheet starting in A1 and going down put 1-31, press Alt-F11, if
there is a window on the left of the screen that says Project VBA Project
then lists the sheets, double click sheet1, if its not there hit ctrl R then
do the same.
Then paste the code and push F5 and that should do it.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"artist4christ" wrote:

and how/where exactly do i insert this? I am still very much a novice at the
finer points of excel

thanks

"John Bundy" wrote:

I think this is what you want, it will create 31 sheets, you can adjust as
needed

Sub main()
For j = 31 To 1 Step -1
i = 2
Sheets.Add
ActiveSheet.Move After:=Sheets(i)
ActiveSheet.Name = Cells(j, 1)
i = i + 1
Next
End Sub
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"artist4christ" wrote:

I am trying to name the sheet tabs to correspond with the days of the month.
ie 1-31. Each book will be a month. How can I do this with out having to
remae all tabs individually?