@ operator inconsistency in VBA .formula
"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
|