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