How are you highlighting? (Normal terminology suggest you select all
the cells. I suspect you mean shading the cells.)

Why are you skipping rows between panel sets? Why not keep the data
contiguous and just increase the first row's RowHeight? It would be
easier to program a solution if there were no blank rows between
panels.

Can you send me your workbook and some sample printouts in PDF format?

gesansomATnetscapeDOTnet

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc