Excel sum function IN VBA

[Sobhani Hafiz]

HI ,

Is it possible to use the excel sum function in VBA? I recorded a macro to
with Excel sum, Then I changed the row number and tried to run from VBA. It
seems that it didnt run.

Any help will be greatly appreciated.

Arefin

 

[Jerry W. Lewis]

Current versions will recognize
Application.Sum()
WorksheetFunction.Sum()
Application.WorksheetFunction.Sum()

Some older versions will only recognize
Application.Sum()

Jerry

 

[Tom Ogilvy]

Added comment:
Older versions being xl5 and xl95. WorksheetFunction was introduced in
xl97.

 

[Robin Hammond]

This is probably what you want

Sub Sum()
MsgBox (Application.WorksheetFunction.Sum(Sheets(1).Range("a1:a2")))
End Sub

Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in