printing multiple worksheets with different specified quantity.

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

Guest

Hi there,

I'm wondering is there any way that I can use code to print multiple
worksheets with different specified quantity. For instance, I've 5 worksheets
and worksheet 1 to print 2 pages, worksheet 2 & 3 to print 3 pages, worksheet
4 to print 2 pages and worksheet 5 to print 4 pages all at once after
specifiying the quantity of all worksheets to print. Zillion helps to all who
can help me out here. God bless u guys.
 
With code you can do this

Sheets("Sheet1").PrintOut copies:=2
Sheets(Array("Sheet2", "Sheet3")).PrintOut copies:=3
Sheets("Sheet4").PrintOut copies:=2
Sheets("Sheet5").PrintOut copies:=4
 
You must log in or register to reply here.

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

Macro for printing 2
Macro to print specified range of several work sheets 2
Copying cell contents a specified number of times 4 mail merge? 2
Userform to Select what worksheets to print 1
How to print multiple sections from different worksheets 1
Hide or chg the font to white? 3
Method to automate page numbers on single worksheet 1
print specific worksheets in specific order. 1

Back
Top