how do you print single page multiply times with increasing page .

  • Thread starter Thread starter aliasmith
  • Start date Start date
Probably easiest by manually entering "Page" in a bottom cell, then do some
code on the back end.

For i = 1 to 20
Range("G40").Value = i
ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1, Copies:=1, Collate
_:=True
Next i

assuming G40 is where you put the 1 and you want 20 pages.
 

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

Percentage Increase 13
how insert printed pages counter 1
numbering pages in footer 1
How do I print a one page spreadsheet multiple time, each with i. 3
Excel formula questin 5
Multiplying the contents of two cells a variable number of times 1
Reverse string on multiply cells 3
How do I multiply ALL CELL in spreadsheet at once by .5 ? 4

Back
Top