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?

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

On Mon, 24 Sep 2007 07:38:01 -0700, Kara Strong
wrote:

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?