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

"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

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

Greetings Jonjo

"Steve K." wrote:

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

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?

"jonjo" wrote:

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

Greetings Jonjo

"Steve K." wrote:

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

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

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.

--
Regards,
Tom Ogilvy

"Steve K." wrote in message
...
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

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

"Tom Ogilvy" wrote:

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.

--
Regards,
Tom Ogilvy

"Steve K." wrote in message
...
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