You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message