AT-Sign appearing in formula inserted via VBA

[Bbcrawford]

To overcome the post's limiting of URL references (ie the "AT-Sign") so I've replaced them below with a "Q".

I often insert formulas into ranges using VBA's .Formula ="=..." method. I recently tried inserting a formula into a cell [ ex. .Formula ="=UNIQUE(....)" ] via VBA. The resulting formula inserted in the cell was =QUNIQUE(...) resulting in only the first item in the list appearing. When I manually deleted the "Q" in the cell with the formula it immediately works as expected and showed the full list of results.
Why is this happening and how can I overcome it when inserting a formula this way.
I am using Office 365
Thanks all in advance
Brian

[JKwan]

try using .FORMULA2 instead
This is because of office 365 spill range

[Paul_Hossler]

More

http://www.vbaexpress.com/forum/show...he-formula-bar

[Bbcrawford]

Thanks all, followed the links and understand it