Microsoft Excel - How to define sections to print on same page

Asked By Jack Rnl on 12-Dec-12 05:54 AM
On a worksheet I have about 300 rows containing texts and pictures.
I want certain rows (containing texts and pictures) to be printed on the SAME page. These adjacent rows I call a "section".
But depending on "something" a number of lines will be inserted BEFORE that section casusing an automatic pagebreak appearing in the section.

How can I make sure my section will always print entirely on a page.


Harry Boughen replied to Jack Rnl on 13-Dec-12 05:13 PM
Hello Jack,
Perhaps you could name cells at the start and end of your section (or even name the whole section) and then write a sheetchange macro to reset the pagebreaks to the start and finish addresses.
Harry