Page Numbering

  • Thread starter Thread starter Mildred Hernandez
  • Start date Start date
M

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....
 
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
 
Back
Top