I am not writing this as code. I have found a VB function that will allow me
to evaluate the cell formulas from within the spreadsheet,
http://www.cpearson.com/excel/GetInfo.htm, but I am not well versed enough to
understand how to make the function available to my Excel environment.
Apparently I need to install it?

"Fredrik Wahlgren" wrote:


"Steve K." <Steve wrote in message
...
I am trying to automatically compare the text of two formulas from
different
spreadsheets. Because the formulas are being fed different raw data they
return different results. When I use the 'exact' function to compare
whether
the formulas are identical it evaluates the results of the formulas, not
the
actual text of the formulas. This is returning to an incorrect "false".

Can you post your current code?

/Fredrik