Excel altering VBA inserted formula

[Yez]

Hello brilliant people,
I am working on a set of utility macros and this one little thing is nagging me. (Ok, lets be honest, theres a ton of things, but this is the one I need help with)
I have VBA adding a table, and then adding a formula referencing an entire column of that table.

Set tbl = ws.ListObjects.Add
    tbl.Name = "tErrors"
    tbl.HeaderRowRange.Cells(1, 1).Value = "Errors"
. . . adding stuff to the table code

ws.Range("F1").Formula = "=tErrors[Errors]"
ActiveWorkbook.Names.Add Name:="ErrorsList", RefersTo:="='Error Handling'!$F$1#"

It works great except for one tiny thing.
The formula in the cell is =tErrors[@Errors]

That pesky @ symbol is being added automagically autostupidly.

Is there a way to force Excel to leave my formula alone?

Thanks in advance! You guys are the best.

Yez

 

[MARK858]

Try....

ws.Range("F1").Formula2 = "=tErrors[Errors]"

 

[Yez]

Try....

ws.Range("F1").Formula2 = "=tErrors[Errors]"

YOU ROCK!

 

[MARK858]

You're welcome

Just for reference (2nd one is more detailed)...

Range.Formula2 property (Excel)

Office VBA reference topic

learn.microsoft.com

Cell Formulas

Office VBA reference topic

learn.microsoft.com