Update Formulas to Reference New Cells Instead of Deleted Ones

[ranuse]

Hi,

I'm having problems with referencing. For example, cell A1 in "Sheet1" contains the formula ='Sheet2'!B1 of current workbook. When I delete the column B in Sheet2, A1 will give me a reference error ='Sheet2'!#REF!.

How can I get the formula to update and accept the new values at B1 rather than the old?

[p45cal]

try:
=INDIRECT("Sheet2!B1")