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