The formulas are sums of HLOOKUP functions, for example
=HLOOKUP(1...)+HLOOKUP(2...). I have to change the formulas to sums of
references, from which the HLOOKUP functions returend values, for example
=b11+z11.
"Tom Ogilvy" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
...
Is this a total discovery requirement - in other words you don't know
anything about the formula in the cells, so you would have to parse the
formula and have procedures to handle any excel function which might be
there?

Please describe your rules for how each function should be handled and all
combinations of functions.

--
Regards,
Tom Ogilvy


"Dmitry Kopnichev" wrote in message
...
Hello
How to replace a function with its resulting reference in a formula? For
example, How to replace =HLOOKUP(1...)+HLOOKUP(2...) with =b11+z11. I
need
to replace in 1000 formulas/cells automatically.