| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error Checking
What would be the quickest way to locate the source of a #REF! error value in
a formula? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Error Checking
Post the formula
Biff "SammyB" wrote in message ... What would be the quickest way to locate the source of a #REF! error value in a formula? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Error Checking
The first choice is to undo the edit which caused the #REF! to appear. It's
usually a case of the edit having deleted a row or column in which a referenced cell used to appear, so either undo (CTRL Z), or if it's to late for that, go back to a backup or an earlier saved version. -- David Biddulph "SammyB" wrote in message ... What would be the quickest way to locate the source of a #REF! error value in a formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error Checking | Excel Discussion (Misc queries) | |||
| Background Error Checking | Excel Discussion (Misc queries) | |||
| Error Checking for Duplicates in List | Excel Worksheet Functions | |||
| Error Checking | Excel Discussion (Misc queries) | |||
| Basic Error Checking in Excel VB | Excel Discussion (Misc queries) | |||
Linear Mode
