View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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.