Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How Do I Avoid #REF! In Formulas?
I am using Microsoft Excel 2007.
My spreadsheet has two tabs, Sheet1 and Sheet2. In Sheet2 I have the following formula going down Col. A linking to data on Sheet1: ='Sheet1'!A15 ='Sheet1'!A16 etc. etc. But if I delete some rows on Sheet1, then the formula on Sheet2 becomes: ='Sheet1'!#REF! What do I need to do so that the dreaded #REF! does not happen when I delete rown on Sheet1? -- tb |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Avoid #div/0! | Excel Worksheet Functions | |||
How to avoid Compatibility Checker MsgBox? VBA to avoid or prevent? | Excel Programming | |||
How do I avoid referencing hidden values in formulas like OFFSET? | Excel Worksheet Functions | |||
what is this, how do I avoid it? | Excel Discussion (Misc queries) | |||
avoid div by zero | Excel Programming |