Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can Enter Page Numbers and/or page ranges separated by commas. | Excel Discussion (Misc queries) | |||
selecting 2 ranges, 1 Worksheet, printing on 1 page PDF | Excel Discussion (Misc queries) | |||
Printing multiple ranges w/o page breaks between | Excel Programming | |||
Printing multiple ranges on one page | Excel Programming |