Automate Page Breaks
 

I have a spreadsheet that has grouped rows. There are several groupings.
When collapsed it prints out 3 pages. When expanded it prints out 6 pages.
I would like to force page breaks in certain areas to keep relevant
information together when expanded. I know where the 5 page breaks need to
be. Could someone provide the VBA code that will clear any existing page
breaks and put in the ones I need?