#REF! after cell deletion
 

Hi there

Imagine you have two sheets in an Excel workbook, and for instance
'Sheet 1' looks at the values in 'Sheet 2' courtesy of a column filled
with formula something like this:

=Sheet2!A1
=Sheet2!A2
=Sheet2!A3
etc.

Is it possible to prevent Excel from replacing the formula at say: A2 in
'Sheet 1' with "#REF!", when the row containing A2 on 'Sheet 2' is
deleted?

--
Colin G Eastwood

Hi
try
=INDIRECT("'sheet2'!A1")

--
Regards
Frank Kabel
Frankfurt, Germany

"Colin G Eastwood" schrieb im Newsbeitrag
...
Hi there

Imagine you have two sheets in an Excel workbook, and for instance
'Sheet 1' looks at the values in 'Sheet 2' courtesy of a column
filled
with formula something like this:

=Sheet2!A1
=Sheet2!A2
=Sheet2!A3
etc.

Is it possible to prevent Excel from replacing the formula at say: A2
in
'Sheet 1' with "#REF!", when the row containing A2 on 'Sheet 2' is
deleted?

--
Colin G Eastwood