Thanks! One more question that may make this quite a bit mor
difficult.

If the user selects a range such as a1:c5, I would like to sum column
of the selected range, then sum column c of the selected range...The
divide the result of the sum of c by the result of sum of b, and the
display final result.

I dont know if that is even possible but thanks for your time

--
impius
-----------------------------------------------------------------------
impius1's Profile: http://www.excelforum.com/member.php...fo&userid=3767
View this thread: http://www.excelforum.com/showthread.php?threadid=57277