Table of contents
TOC
Collapse the table of content
Expand the table of content

Invalid use of Null (Error 94)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

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 anexpression that is Null. For example:

    MyVar = Null 
    For Count = 1 To MyVar 
    . . . 
    Next Count 
    
Make sure the [variable](vbe-glossary.md) contains a valid value.

For additional information, select the item in question and press F1 (in Windows) or HELP (on the Macintosh).

© 2018 Microsoft