There are lots of posts on multiple functions but haven't seen anything that
seems to address my issue. I have a spreadsheet of variable length and I'm
trying to create a macro to automate getting out the needed data. I think I
have the steps of the macro figured out except for this last one.

I've pasted the formula =D5*C5 into an entire blank column, and Excel has
changed the cell reference to the appropriate row number. Then I deleted
errors creating blank cells. Now I want to sum the cells above each blank in
the column. Here's what the column looks like. How do write this function?

0.38
0.55
0.38
8.42
8.84
5.14

3.69
1.24
9.36
1.39

--
Message posted via http://www.officekb.com