printing multiple worksheets with different specified quantity.
 

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.

printing multiple worksheets with different specified quantity.
 

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Richmond" wrote in message ...
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.