Faraz

How about using the 'Formula Auditing' mode for find/replace.

To activate/deactivate use keys Ctrl and ~

If this post helps click Yes
---------------
Jacob Skaria


"Faraz A. Qureshi" wrote:

I often get in the problem of having a wrong filename/range/reference
inserted while updating a formula by way of FIND/REPLACE. The cells, if in
quite a large number, do cause inconvenience upon popup of UPDATE VALUES.

Any idea how to break such an operation?

Thanx in advance!
--
Best Regards,

Faraz