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!

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

"Gordon Humphreys" wrote in message
...

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!