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
|