Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Get operator of a formula | Excel Programming | |||
VBA Get operator in a formula | Excel Programming | |||
Logical operator inconsistency | Excel Programming | |||
What does ! mean as an operator within a formula | Excel Discussion (Misc queries) | |||
"--" operator in a formula | Excel Worksheet Functions |