Thanks for the reply.

One of the columns has wrapped text so the row height varies from row to
row. So I think this would be better of done in Access so I can use the an
Access Report. Unless someone has already written a general VBA printing
routine for Excel.

Thanks for you help Pers and Pete.

"Pete_UK" wrote:

Yes, that is correct if you wanted a general purpose routine, and you
would also need to take account of any header/footer space etc.

However, you may decide that you want 50 rows per page, say, so that
would make it easier to code.

Hope this helps.

Pete

On Mar 26, 10:20 am, slopsjon
wrote:
Thanks for the reply.

Does that mean I would have to work out how many rows and height of cells
will fit on a page with a row of subtotals. In other words would I have to
write my own reporting tool.



"Pete_UK" wrote:
It is not possible using the Data | Subtotals routine - you would need
your own VBA routine to do that.

Pete

On Mar 26, 12:56 am, slopsjon
wrote:
Thanks for the reply. I tried the Subtotals from the menu but that just seems
to Page Break Groups but doesn't put a subtotal on a page that over runs more
than one page. I only have one list of data with no grouping and need a
subtotal of columns on each page.
e.g.
Page 1
row
row
row
end of page running total
Page 2
row
row
row
end of page running total
Page 3
row
row
row
last page Total

Is that possible? Ta.

"Per Erik Midtrød" wrote:
On Mar 25, 10:52 pm, slopsjon
wrote:
I want to print out a spread sheet with subtotals on each page but the number
of rows and height of rows maybe different each time and I don't want to have
to manually adjust the print area and move the subtotal row around.. Is there
anyway to do this automatically in Excel or do I need something with a
reporting tool.

If you go to subtotals on the menu instead of writing your own
subtotal function just check "Page break between groups"

Per Erik- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -