Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print multiple worksheets on one page in Excel? | Excel Discussion (Misc queries) | |||
print multiple, separate rows on each page | Excel Discussion (Misc queries) | |||
How do I print the same sheet multiple times with increasing page. | Excel Discussion (Misc queries) | |||
In Excel, how can I print a long list on 1 page in multiple colum. | Excel Discussion (Misc queries) | |||
How to print multiple worksheets in one workbook on the same page. | Excel Discussion (Misc queries) |