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

"StuartBisset" wrote in message
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

Have you tried Formula2

Peter T