Excel inserts a '@' character in cell formula when written using VBA.

[HighAndWilder]

I am writing a formula using the UNIQUE function to a cell using VBA and Excel inserts a '@' character after the = sign.

Set Ws = worksheets("Results")
Ws.Range("A1").Formula = "=UNIQUE(" & wsStart.Name & "!A2:" & wsStart.Name & "!A13,FALSE,FALSE)"

becomes =@UNIQUE(Data!A2:Data!A13,FALSE) in the cell.

This does not produce a unique list of values in the A2:A13 range but just returns the first value in the list.

If I remove this character manually, the formula works as expected.

Does anybody have any idea how I can avoid this happening?

Thanks

 

[Fluff]

You need to use Formula2 rather than Formula

 

[HighAndWilder]

Thank you Fluff.

I'll check Formula2 out.

 

[Fluff]

You're welcome & thanks for the feedback.