How to SUM

  • Thread starter Thread starter Gordon Humphreys
  • Start date Start date
G

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional format macro not working - almost there 3
Case Select 11
Syntax problems 3
Multiple SUM's in a column 15
summing through end of row 2
Sum Columns with Specific Headings 6
filter column unique for alphanumeric 3
VB-How can I use a variable in a sheet reference? 4

Back
Top