Printing 2 ranges on one page

[John]

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

 

[Neptune Dinosaur]

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.

 

[Mike K]

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