Visual Basic for Applications Reference

Invalid use of Null (Error 94)

See Also Specifics

Null is a Variant subtype used to indicate that a data item contains no valid data. This error has the following cause and solution:

  • You are trying to obtain the value of a Variant variable or an expression that is Null. For example:

    MyVar = Null
    For Count = 1 To MyVar
        . . .
    Next Count

    Make sure the variable contains a valid value.

For additional information, select the item in question and press F1.