Keeping rows together over page breaks

[djclifton]

I have a spreadsheet that has multiple groups of rows that are sometimes hidden and sometimes not but ultimately change the number of pages and page breaks when printing.

I was wondering if there is a way to write a macro that will keep groups of rows together so that they don't split across page breaks or pages when printing?

Has anyone found a way around this?

 

[Boller]

Conditional Page Breaks (Microsoft Excel)

 

[djclifton]

Thanks for the post Boller.

Unfortunately either of these methods work for my application in that i have a range of merged cells within the data set that will not work with data sort function. I also have the same information in cells within the same column that I want to group separately.

It would be great if there was a way to 'keep together' various ranges of rows within the spreadsheet despite what data is in them, when printing but I haven't been able to find anyone that has found a solution to this.

 

[Boller]

http://www.mrexcel.com/forum/excel-...sert-page-breaks-blank-varying-blck-size.html