How to SUM

[Gordon Humphreys]

Still struggling with converting Excel 4 macros. In the old system

=IF(SUM(testarea)>4 (testarea being named on the worksheet)
=FORMULA(“A”)
=END.IF()
worked fine.


What is the VB equivalent ? I can't find SUM in VB



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Don Guillett]

use application.sum(range("a1:a4"))