Hi guys,

I'm wondering how to create a macro that will convert into "values" all the
cells that are referencing to other workbooks (or even other worksheets)
To put it differently, the only formulas I would like to keep are those that
refer to the sheet on which they are written.

=C5 (would like to keep)
=Sheet1!F14 (to convert into "value")
=[Other_Workbook.xls]Sheet1!B15 (to convert into "value")

Could you please help me with this?
Thanks!

P.S. If it's not to complicated, it would be really excellent to have not
only the formula that will do this operation on the active sheet, but also
(another code) to repeat the whole procedure on all the worksheets...