ExcelBanter - How to SUM

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How to SUM (https://www.excelbanter.com/excel-programming/279755-how-sum.html)

Gordon Humphreys[_2_]

How to SUM

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[_4_]

How to SUM

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!

All times are GMT +1. The time now is 10:40 AM.