Multiple Print Area Printed on 1 page based on length

[Holy Inquisitor]

I am looking for some advice to solve the following problems - please see the file attached for reference:

There are 3 stand-alone dropdown cells each hiding/unhiding entire rows in 3 fields:

• Dropdown 1 hides row10-12 from print area 1 (Row 6 to row 12)
• Dropdown 2 hides row26-30 from print area 2 (Row 19 to row 30)
• Dropdown 3 hides row41-46 from print area 3 (Row 36 to row 46)

There are some more rows among the 3 print areas that should be printed (ie: row 1-5, 13-18,31-35)

Is there a way to have the rows printed so, that a macro checks:

• if the ENTIRE 'Print area 2' or even the ENTIRE 'Print area 3' fit on the same page as 'Print area 1' then print all on 1 page
• If Print area 2 does not COMPLETLY fit on page 1 it should be printed on page 2 and the macro should check if Print area 3 fits on page 2 right after Print area 2.
• If Print area 3 dies not COMPLETLY fit it should also print on a new page

Thank you for any help and advice

Please Login or Register  to view this content.