Testing an object varible for Nothing

[Conan Kelly]

Hello all,

How do I test if an object variable is set to Nothing in an If...Then statement?

 

[Bob Phillips]

if obj Is N othing Then
'do something

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Bob Phillips]

Typo

if obj Is Nothing Then
'do something

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Conan Kelly]

Bob,

Thanks for your help,

Conan

Typo

if obj Is Nothing Then
'do something

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

I just did this today. Here's how I did it:

If something Is Nothing Then
...do stuff...
End If

Sincerely,
Pflugs

 

[Conan Kelly]

Pflugs,

Thanks for the help,

Conan

I just did this today. Here's how I did it:

If something Is Nothing Then
...do stuff...
End If

Sincerely,
Pflugs