Excel - Sum Range in VBA Error ? 1

[HobbitK]

Hi everyone .. in a worksheet to sum a Range the formula in a Cell is simply =Sum(RangeName). This works perfectly, I am trying to do the same thing in VBA and assign that total to a variable. I have an Integer variable dimensioned
Dim iFirstRange as Integer
then further in code I am trying iFirstRange = Sum(Rangename). I get an error on the word SUM. It says Sub or Function Not Defined.
Any ideas on how to do this?
Thanks
Michael

 

[TonyJollans]

Hi HobbitK,

SUM is part of Excel, not VBA. You need to use WorksheetFunction.SUM.

Enjoy,
Tony

 

[HobbitK]

Tony ...
Thank you Sir! I am just learning VBA and could not find anything pointing me towards the WorkSheetFunction Keyword!
Michael