| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
summing up cells up to the first unused cell encountered
Hi,
What would be the VBA code to sum up cells up to the first unused cell encountered? For example, if cells A10-A12 have numbers, I want cell A13 to sum from cell A12 up to the first unused cell (in this case A9). I cannot just sum up the entire column A because there is data in cells A1-A8 that I don't want to sum. Thanks very much! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what to do with unused cells | Excel Worksheet Functions | |||
| deleting unused cells / getting rid of inactive cells | Excel Discussion (Misc queries) | |||
| Is there a way to cut off unused cells on a sheet | Excel Discussion (Misc queries) | |||
| how get rid of cells with unused formulas | Excel Discussion (Misc queries) | |||
| Help with getting rid of unused cells or ranges | Excel Programming | |||
Threaded Mode
