print multiple copies of the same page with sequential numbers
 

I need to print several copies of the same form with each page seqentially
numbered to create a book.

Figure out what cell you should put the page number in. (** don't use Excel
footer)

Write a macro that has a for .... next loop. In the loop update the value,
then print

for I = 1 to 200
Activesheet.Range("H40").value = "Page " & I & " of 200"
Activesheet.print ' Not sure my syntax is correct, here. could record
it to get it right.
next


"labrat" wrote:

I need to print several copies of the same form with each page seqentially
numbered to create a book.