View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RICOUK RICOUK is offline
external usenet poster
 
Posts: 1
Default Adding current selection


I am not even sure that this can be done and I have no idea where t
start on this one.
Basically, I need a macro to add up the user selected cells and displa
the result in the last row left one.
for example.
user selects cells C3:C10
the result needs to be displayed in B10

The user then selects C11:C32
the results need to be displayed in B32

The user can select any number of cells within colum C and the cell ro
can be anything.

Is there code which would allow this to happen using a button to star
the macro after the highlighting of the cells?

Thanks in advance

--
RICOU
-----------------------------------------------------------------------
RICOUK's Profile: http://www.excelforum.com/member.php...fo&userid=1879
View this thread: http://www.excelforum.com/showthread.php?threadid=39974