UNIQUE formula in VBA - Referencing Table Columns

[losamfr17]

Hi,

In my code I am using the following statement to create a UNIQUE listing of values for the specified columns.

Sheets("Plan Rollup").Range("M2").Formula = "=UNIQUE(tbl_Plans[[DoorID]:[Tab Name]])"

However, when I run the code the following formula actually appears in cell M2:
=@UNIQUE(tbl_Plans[[DoorID]:[Tab Name]])
The impact is that the SPILL aspect does not work because of the "=@..." instead of "=...". The "@" comes on its own and I don't get why. A single value appears in range M2 instead of the whole unique listing of values. When I remove the "@" manually the formula works fine.

Any idea what's causing the "@" to appear and how to work around it?

Thank you.

 

[Fluff]

For any array formula you need to use Formula2, rather than Formula

 

[losamfr17]

For any array formula you need to use Formula2, rather than Formula

It works. How the heck did you ever learn about this? This is the first time I learn about ".Formula2"
Amazing.
Thank you!

 

[Fluff]

How the heck did you ever learn about this?

Honestly can't remember.

Glad to help & thanks for the feedback.