Hi Rob,

there must be a better way. why not clear the cells rather than deleting
them?

But if you want to disable all formulas you can use Find & Replace and
replace all occurances of = with XX=

At the end rerun replacing XX= with =

XX= is just unlikely to be something in your workbook. You can change it to
anything you want. Save your work before you run this.
--
Thanks,
Shane Devenshire


"Rob McKaughan" wrote:

When you delete a row or column, excel updates all formula references to the
new addresses and replaces references to the deleted cells with #REF.

Any way to programatically disable this?

My specific problem: I've got a workbook that does a whole bunch of number
crunching based on a report pasted into one of the worksheets. The app that
generates that report (MS Money) now has a few more columns & rows I don't
need. I added code to delete this, but excel updates all the lookup
references into that sheet, thus throwing everything off. I looked at
updating all the references and avoiding the deletes, but this ends up being
too painful (lots of lookups on lookups).

So, my idea is to disable the reference updates, do all my deletions &
slashing on the one sheet, then re-enable reference updates, all the
references still pointing where they previously had.