subtotal at the end of printable page

[thoomas]

Hi! My problem is simple. I need a macro, which automatically adds a row at the end of every page just before page break and sums up the numbers for example in column F and puts that subtotal into this newly made row. Data>Subtotals does not work for me, since I don't need to sum up the data according to some criteria. I just want to sum everything that fits in a page. Is this possible at all? Can anybody help?

 

[thoomas]

thanks for the answer. Yes, I have tried this code already before, but I don't like that it creates a new worksheet. I'd like that grandtotal is created automatically inside of the existing worksheet. Is it possible?

 

[thoomas]

anyone can help? I'm

 

[thoomas]

i'm still struggling with that problem. Any ideas?