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

Invalid use of object

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

You tried to use an object in an incorrect way. This error has the following causes and solutions:

  • You tried to discontinue an object reference by assigning Nothing to it but omitted the Setkeyword:

    MyObject = Nothing 
Use the  **Set** statement to set an object to **Nothing**. Assuming `MyObject` is an object, you must set it to **Nothing** with the **Set** statement:
Set MyObject = Nothing 
Omitting the  **Set** keyword is an implicit use of **Let**, which causes an attempt to perform a value assignment, rather than a reference assignment. **Nothing** can't be used in a value assignment.
  • You attempted to use Nothing in an expression.

    Rewrite the expression without the Nothing.

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

© 2018 Microsoft