SUM of above column without column name

[kjurcz]

I am looking to calculate the SUM of the above column in the first blank cell below the last populated row in VBA. I do not want to include the 1st row in the column with the headings.

Example:

If my Data ranges from Cells S2:S1233 - In Cell S1234 I want it to SUM my data above. My data will always be a different amount of rows.

Thanks.

[davesexcel]

There are quite a few various ways to get the result.
Here is one:

Please Login or Register  to view this content.

[kjurcz]

Excellent, thank you so much!

One more question - How would this look differently if it's within another macro? Rather than within it's own Sub.

Thanks again!

[davesexcel]

Dims go at the top, the rest wherever you put it. Code runs line by line. Make sure it is in the correct order. Possibly the rest of the code would be the last lines in your macro.

[shg]

Another way, assuming cell is the single-cell range where you want the result to appear:

Please Login or Register  to view this content.

[kjurcz]

Thank you!!

[shg]

You're welcome.