| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a selection of values and storing result in a variable
This may have been asked before but - I regularly need to find the sum of a
(random) selection of values on a worksheet by selecting the range by and/or holding down the SPACEBAR or CTRL key and then viewing the sum of the values on the status bar. Idealy, I would like to press a button to start a macro to add up all the values that have been selected and store the result in a variable so that then this value can be pasted elsewhere. Any suggestions on the coding? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Storing result of function directly in a variable instead of cell. | Excel Programming | |||
| Storing a selection from a combo box in a variable | Excel Programming | |||
| Storing a value to variable | Excel Discussion (Misc queries) | |||
| Storing variable values in Excel worksheet | Excel Programming | |||
| Storing selection & using the saved selection adress later | Excel Programming | |||
Threaded Mode
