When I put the totals at the top, I'll also use the =subtotal() function. Then
when I apply data|Filter|autofilter, I get to see the subtotals for the visible
rows.



"Chris.F" wrote:

Have you thought about putting the totals at the top of your data rather
than at the bottom. Then the formula can sum right down to 65000 if you
want, and no need for a macro at all.

Chris

"poppy " wrote in message
...
Hi

I made a mess of my last post, but here goes.

I would like to be able to find the last empty row in a worksheet skip
one row and then sum up the totals of each column in this row.

I hope this is clearer than my last post
Thanx for your help

Kind Regards


---
Message posted from http://www.ExcelForum.com/


--

Dave Peterson