Forum Discussion
FloBretzler
Jun 01, 2021Copper Contributor
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 "@"
No RepliesBe the first to reply