Excel likes to @ to my formulas

[JeffGrant]

Hi,

I am not sure if this is an Excel question or a VBA question. Sorry.

Does anybody know to stop Excel adding the @ to formulas? I can't find anyway to prevent this.

I find that when the @ is automatically added to a VBA macro pasted linear regression formula using the LINEST function, that the Intercept does not get calculated. When I manually delete the @ symbol, the intercept is calculate correctly.

My formula in VBA is : Range("AV4").Formula = "=LINEST($AS$4:$AU$4,$AJ$4:$AL$4)"

But Excel likes to make it: Range("AV4").Formula = "=@LINEST($AS$4:$AU$4,$AJ$4:$AL$4)"

When I type the function manually, without the @, Excel does not add the @. It seems only to be because the VBA code is pasting the formula.

As always, any advice is greatly appreciated.

Regards

Jeff