How can Excel adjust page breaks to specific locations?

[Guest]

My office uses Excel to track comments and responses to client concerns. The
comments and responses are on separate rows. As the responses are
ever-changing, the page break locations change as well. We do not want page
breaks between the comment and response. Is there a way to 'tell' Excel where
page breaks are accepable?

 

[Gord Dibben]

If there is is a logical place to insert a manual pagebreak it can be done
through VBA.

What would be a logical and repeatable spot to insert a break?

After a certain phrase or after the row below a cell with a Comment?


Gord Dibben MS Excel MVP