#NAME?

(xlErrName)
Referring to a named range that does not exist.
Text in a formula is unrecognised.
Using an Analysis-ToolPak function when the add-in is not loaded.
Using a worksheet function that does not exist (or has been spelt incorrectly).
Using labels when labels are not allowed.
Entering text that is not enclosed in double speech marks ("some text").
Using an invalid cell range reference.
Referring to another worksheet that does not exist.