I want to write a macro that adds up numbers to the next blank line.
Sometimes there might be 2 numbers to add up, sometimes 15. It seems like
there should be a way to say +sum(move left, move up, end up(for grabbing
that cell and all the ones above it to the next blank line). I can't figure
out a way to do this.

Here is an example of what I want to do (but in a macro)

1
1
1
=+SUM(A1:A3)
1
1
1
1
=+SUM(A5:A8)
1
1
1
1
1
=+SUM(A10:A14)
1
1
1
1
1
1
1
=+SUM(A16:A22)
1
1
1
1
1
1
1
1 =+SUM(A24:A30)
1
1
1
=+SUM(A32:A34)

--
Thanks Very Much!

Art Nittskoff