calculating the sum of a range

T

T. S.

Hi.
I am trying to calculate the sum of a range.
In a sheet I'd just select some cell and type "=SUM(a3:a15)".
But I am trying to do this in a makro and its crucial that I do not
manipulate the sheet.
So I need to call a function - that is available from within a cell -
from outside a cell.
I am looking for something like:
 
D

Don Guillett

sub sumofrange()
mysum=application.sum(range("a3:a15"))
msgbox Merry Xmas
end sub
 
Top