Easy question about Summing numbers VBA.

[dualhcsniatpac]

Trying to make a cell add from 2 other variables. Column D will sum North and South values.

......
ActiveCell.Offset(0, 1) = North.Value
ActiveCell.Offset(0, 2) = South.Value
ActiveCell.Offset(0, 3) = (North.Value+South.Value)
......

Is that the correct way to do it or is there a sum function I can use.
Sum(North, South)???

 

[Andrew Poulsom]

You could try:

ActiveCell.Offset(0, 3) = WorksheetFunction.Sum(North.Value, South.Value)

although it seems hardly worth it.

 

[dualhcsniatpac]

Why do you say that???

Thanks for the tip too

 

[Andrew Poulsom]

Why do you say that???

Thanks for the tip too

It doesn't seem worth calling a function just to add 2 values, and therefore only 1 + operator.

 

[dualhcsniatpac]

What is the easiest and fastest way? How would you do it?

 

[Andrew Poulsom]

In your case I would use the + operator, but I haven't tested which is fastest.