Writing Table Formulas Using VBA

I am trying to make a calculation in a table using VBA. The formula below works in Excel, but when I try to use it in VBA I get a #VALUE! error. Any ideas what I'm doing wrong?

Please Login or Register  to view this content.

I'm wondering if perhaps structured references won't work in VBA formulas?

If it's impossible to do it this way (i.e. with a cell formula), is there a way to do it using VBA ranges, etc?