Printing Multiple Selections on one page
 

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?

Printing Multiple Selections on one page
 

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?

Printing Multiple Selections on one page
 

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?

Printing Multiple Selections on one page
 

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?