View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
zbprtal
 
Posts: n/a
Default Conditional page break if merged rows won't fit on the page.

I am building a spreadsheet with groups of 2-8 rows merged in column A. Is
there a way to insert a conditional page break if a specific group of merged
cells won't fit together at the bottom of a page. I know page breaks can be
inserted manually, but I don't want to have to go back and adjust them all as
I add more data within the spreadsheet. Would some sort of macro work?
Thanks.