Formula elements address

[SS]

Dear All,
I have an excel sheet with so many formulas , I need to build a vb6
application instead of excel sheet .I need sum way to analyze formula
elements then get the address of each cell in the formula to check if that
cell also have a formula and have another elements an so on until i reach
the cells with the data without formulas.
Example :

A1.Formula="=A2*1.5"
A2.Formula="=A3+10"
A3.Formula="=A4-3"
A4.Formula="13"

Thanks in advance

wael

 

[Stan Brown]

I have an excel sheet with so many formulas , I need to build a vb6
application instead of excel sheet

You're saying you want to reinvent (some portion of) Excel?

Please think again. You will almost certainly spend a *lot* more time
in writing a custom application than you'll ever save in run time
over the next century. And then you have the issue of fixing bugs in
your code -- not to mention the ones that are never found but still
give wrong results.