If you assign names to the ranges you're referencing then the named ranges
move with the data when cut. Formulas referencing the name of the range
automatically adjust to the named range's cell coordinates.

From the menu INSERT/NAME/DEFINE

--
Kevin Backmann


"DanF" wrote:

Afternoon all

I have a sheet, say Sheet 1, which has no formulas or macros; but is
referenced by a whole host of other sheets in the workbook which use the data
in Sheet 1 to provide the user with a load of useful stuff.

If (or when) the users use 'Edit Cut' in Sheet 1 moving data around, the
formulas in the sheets referencing Sheet 1 try to upate their references and
I'm left with #REF erorrs everywhere.

Is there a way around the default 'Cut' functionality or a way to preserve
the formula references so that this doesn't happen?

Best regards,
DanF