If you set objects to Nothing, then test their nothingness, this suggestion might help you. If you declare an object as New and later set it to Nothing, VB won’t set the object to Nothing. For example, if you declare an object using this code:
Dim oSomeObject As New SomeClass
And later set it to Nothing using this code:
Set oSomeObject = Nothing
The object does terminate, but a new instance is immediately instantiated, so it appears the object hasn’t been set to Nothing. You can test this by going to the Immediate window and testing ‘?(oSomeObject = Nothing).’ It displays False. If you declare an object and explicitly set it to New, you can set the object to Nothing. For example, if you declare an object using this code, the object will be set to Nothing:
Dim oSomeObject As SomeClassSet oSomeObject = New SomeClass'.... some code ...Set oSomeObject = Nothing