Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all
Is there an easy way to extract the parameter values used in a function, e.g. if a cell contains a formula "=sum(a1,a2,a3)", I'd like to get an array with the values (a,b,c) ( =values of a1, a2, a3) being used in the function. The function wizard in excel takes the function apart in this way, but it looks quite complex to try and do something similar. I am tempted to take the formula apart as a string, going for "(" and ",", but it doesn't look easy. Maybe there's a ready made procedure for this? Thanks for your input |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Logic If formula - multi-parameters can not get to work?? | Excel Worksheet Functions | |||
SUBSTITUTE formula -- variable spacing between parameters?? | Excel Worksheet Functions | |||
Parameters for an excel formula | Excel Discussion (Misc queries) | |||
formula to check balances within parameters | Excel Worksheet Functions | |||
MID formula not extracting what I want. | Excel Discussion (Misc queries) |