I've subtotaled a table, and need to print it out. I would like all rows
which form part of the subtotal to print together on one page. If there's
not enough room on the page, I'd like a page break after the previous
subtotal.

In Word, I can use 'Keep lines together'. Is there an equivalent in Excel?

If not, how would I program this? Is it possible to tell in VBA where the
page beak is? And, if I don't like where it is, can I move it to a different
row?

--
Thanks,
Fred
Please reply to newsgroup, not e-mail