Printing specific areas on one page

[MarkRS]

I have designed a report and I would like a macro that lets me print off only certain columns and rows that correspond to two tables of data that I can attach to a button on the screen.

The columns involved are A to P, but I only want to print off rows 1 to 3, 7 to 10, 22 to 27, and 36 to 52.

I tried to record a macro to set the print areas but when I print it wants to print each set of rows on a different page, whereas ideally I would like all the data on one page.

And if not too cheeky is there a way I could get the printer select menu to appear before it prints?

Thanks

Mark

 

[Andrew Poulsom]

Can't you (temporarily) hide the rows you don't want to print? Here's another possibility:

http://spreadsheetpage.com/index.php/tip/creating_a_linked_picture_of_a_range/

 

[MarkRS]

It's not for me, it's something my boss wants. Considering he can't save a document without help I don't want to try and explain the intricacies of hiding/unhiding rows.

 

[Andrew Poulsom]

It's not possible to print a discontiguous range on one page. You could use a macro to hide the rows before printing.