Printing Multiple Selections on one page

[Ben]

In my sheet, I have mutiple sections which are not all connnected. Right now
I have a macro, go through each of the sections and detect which one has
information in it, and then it adds that whole section to my print selection.


My problem is, when I print selection, it prints each seperate area on a new
page even though the Range is Union of all the smaller areas.

Is there a work around for this which does not involve copying each
selection to a new sheet and printing it all as one?

 

[Mike Fogleman]

You could try the free Excel add-in "Print Selections Only".
http://www.realezsites.com/bus/primitivesoftware/products.php

Mike F

 

[Ben]

I'm looking or something similar, except my goal is to have my macro call the
print function itself.

 

[John]

Ben,

I'm looking to do the same thing. Any luck?