.formula doesn't create the desired formula in a cell

[pingme89]

I have the following line of code that should place a formula in a cell.

ThisWorkbook.Worksheets("Log").Range("AA1").Formula = "=IFERROR(UNIQUE(FILTER(Log!$E$2:$E$100, Log!$E$2:$E$100<>" & Chr(34) & Chr(34) & ")), " & Chr(34) & Chr(34) & ")"

The desired formula result should be: =IFERROR(UNIQUE(FILTER(Log!$E$2:$E$100, Log!$E$2:$E$100<>"")), "")

However, what I actually get is : =@IFERROR(UNIQUE(FILTER(Log!$E$2:$E$100, Log!$E$2:$E$100<>"")), "")

If I manually go into the cell and remove the "@" symbol, the formula works. How can I put that formula into the cell without manual intervention for it to work?

 

[MARK858]

Try...

ThisWorkbook.Worksheets("Log").Range("AA1").Formula2 =

 

[pingme89]

That worked. But why? What is Formula2 and when do I use it?

 

[MARK858]

Maybe the article in the link below will help explain

Cell Formulas

Office VBA reference topic

learn.microsoft.com

 

[Peter_SSs]

@pingme89
I suggest that you update your forum profile (click your user name at the top right of the forum, then ‘Account details’) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

It would make it easier for helpers to know to suggest things like .Formula2 as that is not applicable to all versions.

 

[pingme89]

That was very insightful. Thank you for your knowledge.

 

[pingme89]

Noted and updated. Thank you.

 

[MARK858]

That was very insightful. Thank you for your knowledge.

You're welcome

 

[Peter_SSs]

Noted and updated. Thank you.

Thanks for updating.