checking "Object" value

[JoeSmoe55]

Is there a way to check to set if a Object is not initialized? i.e...

if Object = nothing then....

I know the above example doesn't work but is there another way other than VBA throwing an error?

Thanks,

Joe

 

[jsteph]

Use
If Object Is Nothing Then...
--Jim

 

[RoyVidar]

Except if you've done so called "implicit instantiation", where any reference to the object will reinstantiate it - see for instance Instantiating Objects, method 3 vs the other two methods.

Roy-Vidar