United States
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers. Correct a #REF! error
Applies to: Microsoft Office Excel 2003
Occurs when a cell reference (cell reference: The set of coordinates that a cell occupies on a worksheet. For example, the reference of the cell that appears at the intersection of column B and row 3 is B3.) is not valid.
Possible causes and solutionsChange the formulas, or restore the cells on the worksheet by clicking Undo
Start the program.
Make sure that you're using the correct DDE topic.
Check the function to see if an argument (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) refers to a cell or range of cells that is not valid. For example, if the macro enters a function that refers to a cell above the function, and the cell that contains the function is in row 1, the function will return #REF! because there are no cells above row 1. |
Email this link
Printer-Friendly Version
Share
Show All
Hide All
, and then click Trace Error if it appears.
immediately after you delete or paste the cells.| Related Web Sites |
| ||||||
