How can I detect if a var is set?

[Greg]

Sample

Dim X as ABC 'ABC is a com object

If X = nothing then
set X = New ABC

How do I do the If statement to see if I have set it or not?

 

[Chip Pearson]

Greg,

Use the IS operator. E.g.,

If X Is Nothing Then
Set X = New ABC
End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com