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

Occasional Visitor

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

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