View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike K Mike K is offline
external usenet poster
 
Posts: 104
Default 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