Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

@ operator inconsistency in VBA .formula

7 views
Skip to first unread message

StuartBisset

unread,
May 21, 2021, 9:23:38 AM5/21/21
to
Following the introduction of dynamic array formula the @ symbol has automatically appeared in front of many formula where excel has deemed that 'implicit intersection' ought to be enabled - ie SPILLing is not intended.

However the "@" symbol is not there if you attempt a selection.formula command in VBA.

ie in excel cell A1 might show "=@INDEX(..." and in VBA range("A1").formula would return "=INDEX(..."

Can anyone suggest a method for returning the formula as visible in excel, including the @ symbol?

Thanks

Peter T

unread,
May 21, 2021, 2:49:23 PM5/21/21
to
"StuartBisset" <stuart...@gmail.com> wrote in message
Have you tried Formula2

Peter T


0 new messages