Using VBA and FormulaLocal "@" is added automatically and the formula changes the output.

Occasional Visitor

Hello, 

I'm trying to add a formula via VBA and .FormulaLocal into a worksheet. 

The Formula is simple and as follows: "=AVERAGE(IF(ISNUMBER(E8:E11);E8:E11;0))"

 

When I enter it manually it works perfectly. 

Although if I enter it via VBA the character "@" (implicit interception operator) is added automatically and the formula changes into: ""=AVERAGE(IF(ISNUMBER(@E8:E11);E8:E11;0))"

 

The Output of the formula including "@" is different (0 instead of some percentage) although in the Help Popup it says that the output is not altered by the additional "@"

0 Replies