Performing Multiple Functions in a Column

[dhoward via OfficeKB.com]

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

 

[Mallycat]

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

 

[dhoward via OfficeKB.com]

Thanks. It worked!

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