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?

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

Mike F
"Ben" wrote in message
...
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?

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




"Mike Fogleman" wrote:

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

Mike F
"Ben" wrote in message
...
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?

Ben,

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

"Ben" wrote:

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




"Mike Fogleman" wrote:

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

Mike F
"Ben" wrote in message
...
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?