Hi,

What would be the VBA code to sum up cells up to the first unused cell
encountered? For example, if cells A10-A12 have numbers, I want cell
A13 to sum from cell A12 up to the first unused cell (in this case
A9). I cannot just sum up the entire column A because there is data in
cells A1-A8 that I don't want to sum.

Thanks very much!