I have a large spreadsheet that I have setup in groups of 40 rows of 60. The
60
categories are separated by a row that is formatted with a yellow
background. Is there a way to create a print macro that would recognize the
yellow and keep everything beneath the yellow on the same page. Something
like in Access where you can create a report and use the Keep Together rule
so that if the list gets to the bottom of the page and there is not enough
room on the page to print the category with the rows of that section, it
would start a new page. The sixty rows beneath the categories can fluctuate
depending on if there is data in the rows so sometimes there could be 1 row
and sometimes 10 and sometimes 60. Any suggestions?