#REF!

A

Alex

What does this error mean? Is there a way to prevent it
from ending up in my worksheet functions?\

Thanks.
Alex
 
J

John McGimpsey

You get the #REF! error when a cell reference isn't valid.

To prevent it, don't use invalid references.

To remove it, see "Correct a #REF! error" in XL Help.
 
D

Dave Peterson

An example of one way to get them:

Put =A1 in cell B2
Delete row 1
Look at the B1 (where B2 moved to).
 
Top