I need to compare two formulas that are being fed different raw d.

[Guest]

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".

 

[Fredrik Wahlgren]

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

 

[Guest]

Try the .Formula property of the respective range or .FormulaR1C1

Greetings Jonjo

 

[Guest]

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?

 

[Guest]

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?

 

[Tom Ogilvy]

in each workbook where you want to use the function, go to the VBE and with
that workbook as the active project, do Insert=>Module. Paste the code into
that module.

then you should be able to use it in you worksheets in that workbook.

 

[Guest]

thanks for your help. I think that did the trick.