#REF! after cell deletion

  • Thread starter Thread starter Colin G Eastwood
  • Start date Start date
C

Colin G Eastwood

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Copy data from a row to a column 3
***Help on writing a vba code 12
Excel formula referencing cells 4
Please help with Excel Formula 2
Copy Data from One sheet to Different Sheets 1
Copy a sheet contained formulas from one workbook to another and remove file links 3
Copying Rows of Formulas 4
Sumproduct function allow a lookup for one Date to check if it fallsin Date Range in other table 9

Back
Top