NULLREF

An object (a singleton) and not a class. It represents the NULL reference, and could occur, for example, when you intersect two disjoint ranges, or when a formula depends on a cell that has been deleted. For example, when you put in some cell =test(B5) and then right-click on column B and delete it. To test when something is the NULL reference, just do x === NULLREF.

In this article

Not finding the help you need?