How to Sum in a Macro

Hi,

The last thing I want my macro to do is scroll to the last row of my table and SUM Column H. The rows in my table vary every time I run the report, so normally I would use this formula:

=SUM(H2:OFFSET(H2,COUNTA(A:A)-2,0))

Column A will always have data, so this will give me the accurate number of rows for the sum range.

When I write that formula into the end of my Macro, it doesn't work. I look at the formula bar for the cell that should show the sum, and the formula has extra parentheses that I did not write. How can I write the SUM formula into the Macro??? *Note- I can also use the name of the column, which is "Days". I'm just not as comfortable using named ranges as I am with cell references.

Also, the main part of this macro is to take about 20 tables from other sheets and put them all into this one sheet. So I have tried just using the last column as a sum, but when my Macro pastes the last table it does not make it part of the table, so it sits below my SUM formula.

Please Login or Register  to view this content.

Hi Bob,

Could you explain that formula a bit? I don't really understand it. I'm pretty new to writing Macros. I've just started to record them and look at that code to learn it as I go

It would just end up as

=SUM(H2:Hn)

where n is the last row of data in column A.