Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Command Button to Sum specific cells in a range
Hello all,
I am trying to create a command button that will sum a specific cell to a "total" cell located beneath it. For instance, I will have numbers ranging from B3 all the way to CB3 and want the values in these cells to be added to the corresponding cells in, say, B16 through CB16. Therefore, whatever is in cell B3 will be added to cell B16 and that will be the new value in cell B16, and so on. I would like to make this dynamic, as the data may extend past column CB. Also, I will have other data to add in rows 4 through 12. Currently, I am doing this very inefficiently by summing each cell, so the code is very repetitive and long. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
modify a macro to apply to a specific range of cells | Excel Discussion (Misc queries) | |||
Macro to Specific Cells in a Range | Excel Programming | |||
Macro to Select Specific Cells in a Range | Excel Programming | |||
command button that puts specific numbers in a range of cells | Excel Programming | |||
command button to move user to specific spot on different sheet | Excel Programming |