Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Colin G Eastwood
 
Posts: n/a
Default #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
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Display cell value on a chart. Andrew Constantinidis Charts and Charting in Excel 1 January 8th 05 05:36 AM
How do I set a cell to "Empty" so that it does not display in a ch Ian Charts and Charting in Excel 3 January 7th 05 02:12 AM
make a cell empty based on condition mpierre Charts and Charting in Excel 2 December 29th 04 02:01 PM
Cell value as chart scale maximum Phil Hageman Charts and Charting in Excel 9 December 17th 04 03:09 PM
Transferring cell content between workbooks using cell references Kiwi Mike Excel Discussion (Misc queries) 2 November 28th 04 12:31 AM


All times are GMT +1. The time now is 07:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"