A bit more explanation along with before and after examples

--
Don Guillett
SalesAid Software

"Emile" wrote in message
...
I would like to select a range of cells using my mouse and then start a
macro based on the selected range.

How do I code the macro to use the mouse selected range for the SUMIF
functions that followin the macro?

The range would be not be the same every time. The SUMIF function would
be the same for any selected range.

Thanks in advance for your help