How to use the CountSum funtion of worksheet in Macros

S

saraveenan

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

Martin Fishlock

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.
 
Top