Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Multiple Worksheets | Excel Discussion (Misc queries) | |||
Macro to select Quantity Printing | Excel Programming | |||
Printing? Worksheets not printing the same on multiple pc's! | Excel Programming | |||
Printing Multiple Worksheets | Excel Programming | |||
Printing Multiple Ranges from Multiple Worksheets | Excel Programming |