ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Testing an object varible for Nothing (https://www.excelbanter.com/excel-programming/369628-testing-object-varible-nothing.html)

Conan Kelly

Testing an object varible for Nothing
 
Hello all,

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

--
Thanks for any help anyone can provide,

Conan Kelly



Bob Phillips

Testing an object varible for Nothing
 
if obj Is N othing Then
'do something

--
HTH

Bob Phillips

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

"Conan Kelly" <CTBarbarin at msn dot com wrote in message
...
Hello all,

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

statement?

--
Thanks for any help anyone can provide,

Conan Kelly





Bob Phillips

Testing an object varible for Nothing
 
Typo

if obj Is Nothing Then
'do something

--
HTH

Bob Phillips

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

"Conan Kelly" <CTBarbarin at msn dot com wrote in message
...
Hello all,

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

statement?

--
Thanks for any help anyone can provide,

Conan Kelly





Conan Kelly

Testing an object varible for Nothing
 
Bob,

Thanks for your help,

Conan


"Bob Phillips" wrote in message ...
Typo

if obj Is Nothing Then
'do something

--
HTH

Bob Phillips

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

"Conan Kelly" <CTBarbarin at msn dot com wrote in message
...
Hello all,

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

statement?

--
Thanks for any help anyone can provide,

Conan Kelly







Pflugs

Testing an object varible for Nothing
 
I just did this today. Here's how I did it:

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

Sincerely,
Pflugs

"Conan Kelly" wrote:

Hello all,

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

--
Thanks for any help anyone can provide,

Conan Kelly




Conan Kelly

Testing an object varible for Nothing
 
Pflugs,

Thanks for the help,

Conan


"Pflugs" wrote in message ...
I just did this today. Here's how I did it:

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

Sincerely,
Pflugs

"Conan Kelly" wrote:

Hello all,

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

--
Thanks for any help anyone can provide,

Conan Kelly







All times are GMT +1. The time now is 08:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com