Evaluate specific row of table

[jstevens]

Is it possible to evaluate the sumproduct of a specific table row using VBA?

I know that "@" will evaluate the ActiveCell in the table correctly. I would like to evaluate a specific row in a table; let's use row 3 as an example.

MsgBox Evaluate("=SUMPRODUCT(ABS(tblMyTable[@[January]:[December]]))")

[HansV]

Like this:

Code: Select all

MsgBox Evaluate("=SUMPRODUCT(INDEX(ABS(tblMyTable[[January]:[December]]),3,0))")

[jstevens]

Hans,



Thank you!