with /data/ totals check pagebreak between groups.

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Fred Smith" wrote:

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?