Formula elements address

  • Thread starter Thread starter SS
  • Start date Start date
S

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
 
Sun said:
I have an excel sheet with so many formulas , I need to build a vb6
application instead of excel sheet
Click to expand...

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.
 
Back
Top