Page Numbering

[Mildred Hernandez]

I have one excel sheet, and need to print let's say 60
copies. the 60 pages out of the same sheet should be
enumerated from 1 to 60. I have gone to the footer, but
recognizes my sheet as 1 page. There must be a way....

 

[Jon Peltier]

Mildred -

I have in the past written VBA routines like this

Sub Print60()
Dim i As Integer
For i = 1 To 60
' Put counter in cell A1
ActiveSheet.Range("A1").Value = i
' Print sheet
ActiveSheet.Printout
Next
End Sub

- Jon