Printing multiple ranges in multiple worksheet into a single printout

**frousseau** · 08-15-2012, 10:53 PM

Hi,

I have a workbook containing multiple worksheets having multiple ranges (same range names on each worksheet). I'm trying to find a way to loop through each worksheet and print each defined ranges on it (only the data of each worksheet changes) with a different page number.

Since the end result can be 50 pages or more, I would like to combine into one single printpreview, printout (for a pdf printer) or directly to pdf. The single printout combination is really my issue since I am able to launch all pages separately.

Is there someone who know how I can achieve this?

Thanks!

**JBeaucaire** · 08-16-2012, 12:38 AM

Can't you just set the "Print Range" on each sheet to just the specified range (or whatever you want on each sheet), then select the sheets wanted all at once and "print selected sheets". That would print them all into a single print job. Right?

**frousseau** · 08-16-2012, 08:30 AM

Hi,

In fact, I am verifying that there is data in the range. If not, it is not printed. This is why your suggestion would not work.

**JBeaucaire** · 08-16-2012, 08:53 AM

You will need to adapt the macro to "do your test" on each worksheet, but this is the basic syntax for cycling through all the worksheets, doing a test, and adding sheets to an array of sheetnames. Then the array of sheetnames is selected and all printed as a single print job with the default printer.

Please Login or Register  to view this content.

Your test could be as simple as making sure there are cells in the range with something in them:

Please Login or Register  to view this content.

**frousseau** · 08-16-2012, 09:18 AM

Hi again,

Here is a sample workbook to help explaining. In this exemple, I would only need to print the worksheet "FIRST" with "Cost 2011" since there is a total and "Cost 2012" on worksheet "SECOND" (since there is a total). There would be a total of 2 pages to be printed (same batch since this is only an example and it can be 50, 100 pages).

Thanks!Attachment 174598