print multiple copies of the same page with sequential numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing sequentially numbered worksheets 3
Excel Sequential Numbering System 0
printing multiple worksheets in a workbook 1
PRINT PAGES FROM DIFF TABS WITH PAGE NUMBER 11 TO 19 1
Sequential numbering on a blank form? 1
copy worksheet and automatically name 4
Page Numbers not working 1
Page Numbers not working correctly 2

Back
Top