WorkSheetFunction Error 1004 2

[HobbitK]

Hi everyone ...
Trying to Sum a named Range in VBA and assign that to a variable.

Here is the line of code
iLastbalance = WorksheetFunction.Sum("LastBalance&quot

iLastBalance is an argument in a Function.

When the code runs I get an error box saying "RunTime Error 1004: Unable to get the Sum property of the WorkSheetFunction Class"

Any ideas?
Michael

 

[Zathras]

Assuming you have a range defined with the name "LastBalance" and you are trying to sum all of the cells in that range, then all you need to do is modify one line of code as follows:

 iLastbalance = WorksheetFunction.Sum(

[blue]

Range(

[/color]

"LastBalance"

[blue]

)

[/color]

)

 

[HobbitK]

Zathras,
Thank-you Sir. I had tried WorksheetFunction.Sum.Range,
but never thought to put it inside a ()
Thaks again,
Michael

 

[bryanbayfield]

Easier just to write:

[SUM(Last_Balance)]

 

[TonyJollans]

Have a star for that one Bryan, but can you tell me where it's documented.

Tony

 

[bryanbayfield]

Have a look at the evaluate method - square brackets are a shorthand way of invoking it.

cheers matey.

Bryan.