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

I'm not sure if you are trying to do this manual or in VBA. The
principle is
1) select all the blanks
2) use the autosum


To select the blanks, first select the entire column, then use
goto\special\blanks. This will select them all at once. Then just
click the AutoSum tool and you're done. You should ( I assume) be able
to do both of these things using Application.WorksheetFunction in VBA

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=554743

Thanks. It worked!

Mallycat wrote:
I'm not sure if you are trying to do this manual or in VBA. Th
principle is
1) select all the blanks
2) use the autosum

To select the blanks, first select the entire column, then us
goto\special\blanks. This will select them all at once. Then jus
click the AutoSum tool and you're done. You should ( I assume) be abl
to do both of these things using Application.WorksheetFunction in VBA

Mat

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200606/1