Printing 2 ranges on one page
 

I have a worksheet that has a couple columns of common info row heading info
then several multicolumn sections of info associated with each row heading.
I have defined two print ranges:
PrintRange1 covers all the row headers
PrintRange2 covers the first multicolumn data area
What macro code will print a page that shows the common row headings in the
left and the associated multicolumn info on the right of the page?

I appreciate your help, -John

Printing 2 ranges on one page
 

Someone may have a better way of doing it, but one way would be to write a
macro which temporarily and strategically hides parts of the worksheet so
that the gear that you want will all appear on one "page". You'd use the
Selection.PrintOut method and then unhide everything afterwards. If I were
doing it, I'd also turn the ScreenUpdating off and then back on again
afterwards to avoid screen flicker.
--
Time is just the thing that keeps everything from happening all at once


"John" wrote:

I have a worksheet that has a couple columns of common info row heading info
then several multicolumn sections of info associated with each row heading.
I have defined two print ranges:
PrintRange1 covers all the row headers
PrintRange2 covers the first multicolumn data area
What macro code will print a page that shows the common row headings in the
left and the associated multicolumn info on the right of the page?

I appreciate your help, -John

Printing 2 ranges on one page
 

John,
You may want to try Jim Cones addin "Print Selections". It is
more straight forward printing rows, but you may be able to make it work for
you.

Mike

"John" wrote:

I have a worksheet that has a couple columns of common info row heading info
then several multicolumn sections of info associated with each row heading.
I have defined two print ranges:
PrintRange1 covers all the row headers
PrintRange2 covers the first multicolumn data area
What macro code will print a page that shows the common row headings in the
left and the associated multicolumn info on the right of the page?

I appreciate your help, -John