We are in the process of making a spreadsheet in excel that, depending
on the user's input, will show/hide groups of rows to display only the
relevant information. For example, if user says no to question 1, hide
the rows 2-10. There are approx 20 groups of rows in the spreadsheet.

The problem with the report as it works now is that the page breaks are
positioned directly in the middle of a logical group of rows(ie: rows
all related to the same question). I want the page breaks to fall on
the boundaries of these groups, not in the middle. We have tried adding
a column of merged cells on the left the height of each logical group of
rows, but the page break still splits the merged cell. I am thinking
now that it will have to be done with VBA somehow.

Does anyone have any idea how to position page breaks so that they don't
split a group of rows ?

Thank You