Batch print incremental numbers

  • Thread starter Thread starter Silvester
  • Start date Start date
S

Silvester

This seems fairly simple but I'm not sure how to achieve it.

Using Excel I have to simply print a sequential number on the top right of a
number of pages. When that page #1 is printed that sequential number will
increment to #2, page 2 is printed, etc

Cand anyone please direct me as to how to do this with Excel ?
 
Sub Macro1()
Range("A1") = 1
Do Until Range("A1") = 301
ActiveSheet.PrintOut Copies:=1
Range("A1") = Range("A1") + 1
Loop
End Sub
 

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

template + page numbers 1
Numbering documents 1
Printing a large/long spreadsheet on legal size paper problem 1
sequentally numbering records in a report 2
Excel 2007 print option gone 1
Sequential page numbers for one page 3
Building a Dynamic Sheet number in a formula 2
Numbering documents (revised) 1

Back
Top