Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I write macro to sum numbers up to next blank line?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help (Uppercase multiple ranges?) | Excel Discussion (Misc queries) | |||
Have a formula yield a true blank that disconnects graph line | Charts and Charting in Excel | |||
Macro to hide blank cells in a range | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
enter numbers in blank cells | Excel Worksheet Functions |