Posted to microsoft.public.excel.misc

jase

external usenet poster

Posts: 117

printing multiple sheets

I need to print multiple sheets using VBA. I am currently using a looping
function to colate them that says

For intStart = 1 To intCopies
Sheets(1).Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets(2).Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Next intStart

Is their a faster way to do this?

thanks,

Jase

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Printing multiple sheets in Excel	Syed Shah Alam	Excel Discussion (Misc queries)	1	March 18th 08 03:42 PM
Printing Multiple Sheets	Chad	Excel Discussion (Misc queries)	3	October 17th 07 10:23 PM
Printing multiple sheets at one time	Jamie	Excel Worksheet Functions	1	October 2nd 07 06:29 PM
Printing Multiple sheets	light_life_love	Excel Discussion (Misc queries)	0	August 25th 05 08:52 PM
Printing Multiple sheets on ONE?	onesidered	Excel Discussion (Misc queries)	2	August 10th 05 06:58 PM

All times are GMT +1. The time now is 09:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us