View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Simka Simka is offline
external usenet poster
 
Posts: 17
Default 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?