![]() |
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 |
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 |
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 |
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 |
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 |
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