In a cell on row 5, say A5, put the number 1. In the cell below, use a formula like

=A5+1

and copy down for 20 rows.

Then print, and enter 21 into cell A5, and print again. Then 41, etc.

A macro to use once the formulas are set up is (assuming your activesheet is the one you want to
print):

Sub PrintMySheet()
Dim i As Integer

For i = 1 to 281 Step 20
Range("A5").Value = i
Application.CalculateFull
Activesheet.PrintOut
Next i
End Sub

HTH,
Bernie
MS Excel MVP


"srctr" wrote in message
...
I want to be able to print a form and have certain rows be numbered when they
print. For example the first time I print it I may print 2 copies and I want
rows 5 thru 24 to number on the 1st page 1-20, 2nd page 21-40, etc. If I
need to print again this time I want the rows to be numbered 41-60. It is an
sign up sheet and we need to have a unique sheet that keeps a running tally.

I would like this instead of creating one long worksheet with all the rows
numbered from 1 thru 300. I suspect it would be a macro where I would have
to enter at least the beginning row number.

Thanks for any help
--
cao