| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| varible table not | Excel Worksheet Functions | |||
| Offsetting a varible?? | Excel Programming | |||
| Range name as varible | Excel Programming | |||
| Varible in a Range | Excel Programming | |||
| how to start from varible row | Excel Programming | |||
Linear Mode
