Remove @ sign from UNIQUE formula

[alibini]

Hi Experts.

I have code in vba whereby I have a formula placed into a cell.

Eg
[A1] = "=UNIQUE(FILTER(Sheet1!$D:$D,(Sheet1!$AD:$AD=L11)*(Sheet1!$F:$F=""-"")*(Sheet1!$CG:$CG<>0)),,FALSE)"

The problem is that when vba puts the formula into cell A1, it adds an @ like this:

=@UNIQUE(FILTER(Sheet1!$D:$D,(Sheet1!$AD:$AD=L11)*(Sheet1!$F:$F="-")*(Sheet1!$CG:$CG<>0)),,FALSE)

This prevents the SPILL that I want.

Is there an easy solution here to post the formula and force non inclusion of the @ ?

THANKS

 

[dreid1011]

If you are using .Formula to assign the formula, you can change it to .Formula2.

 

[alibini]

If you are using .Formula to assign the formula, you can change it to .Formula2.

Such a simple solution. Thanks so much.

 

[dreid1011]

You're welcome, and happy to help.

 

[Alex Blakenburg]

@alibini, if you are using Unique you can't be using Excel 2016. Can you please update your account profile to show the version you want suggested solutions to work on.