New dynamic Array Formulas and VBA

[dipkchopra]

Hi all,
I am trying to insert in an excel cell the new dynamic array formula - 'Unique'

In very simplistic terms:

My VBA code reads like - cells(9,9) = "=UNIQUE(C9:C240)"

But when I run the code, excel is inserting '@' symbol in my formula and the final output reads like:

"=@UNIQUE(C9:C240)"

How do I get rid of this @ in my formulas inserted through VBA

 

[Fluff]

You need to use Formula2

 cells(9,9).Formula2 = "=UNIQUE(C9:C240)"

 

[dipkchopra]

You need to use Formula2

 cells(9,9).Formula2 = "=UNIQUE(C9:C240)"

Thanks a ton - That was very helpful and lightning quick

 

[Fluff]

You're welcome & thanks for the feedback.