hello.
I have a page set up macro, and need to configure my print titles line of
activesheet.pagesetup

I see where I can insert the exact rows I want, but mine vary from file to
file, so I need to have a variant so that I can base the number of rows on
some variant criteria.

I was thinking that I could make this based on the rows being filled in with
a color, or no-fill.

The color is typically mid-grey-- color index # 15.


Thank you.