Jun 01 2021
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 "@"