Compare two Formulas

[ghowlett]

Hi,

I wish to find an algorithim (in any language or pesudo) to compare two formulas i.e.

=avg(a1:a10)+A2

compare to

=avg(MrRange)+A2

I have a vb.net app that needs to report this change. The idea is the changes will be displayed in red in rich text control.

Any ideas / help much appreciated.

Many Thanks

Gary

[bertlef]

you shoud look into the .FormulaR1C1
if your formula 1 is in A5 and your formula2 is in A7 you shoud do something like

if Range("A5").FormulaR1C1 = Range("A7").FormulaR1C1 then ...

[ghowlett]

Hi,

Thanks for replying, much appreciated. I think need to explain myself further.

I have an application where I read the cells of an excel spreadsheet in VB.NET 2005, and over time I compare the changes.

Therefore say there is a formula in a particual cell which someone has altered. What I would like to do is compare the previous and new formulas and highlight the changes between them.

Any ideas on this?

Many Thanks

Gary