Hi:

there is no need to use a macro in this situation just use the following:

=sum(a:a) if the whole column or

=sum(a1:a20) if a range.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"saraveenan" wrote:

I need to count the sumn of values present in a column or row using Excel
macros.