T
todd.huttenstine
Hey
I have this string that is programatically inserted into a cell as an
array formula:
=1*MID(A2,MATCH(FALSE,ISERROR(1*MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)),
0),LEN(A2)-SUM(1*ISERROR(1*MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1))))
It returns a valid result. I would like to be able to evaluate this
formula and get the result in VBA before I insert it into a cell.
How do I do this?
Thanks
I have this string that is programatically inserted into a cell as an
array formula:
=1*MID(A2,MATCH(FALSE,ISERROR(1*MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)),
0),LEN(A2)-SUM(1*ISERROR(1*MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1))))
It returns a valid result. I would like to be able to evaluate this
formula and get the result in VBA before I insert it into a cell.
How do I do this?
Thanks