Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nothing?
What does it mean by setting an object variable to "Nothing"?
Thanks!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nothing?
Hi CK,
Nothing is a VB (and hence VBA) keyword that only applies to object variables, and determines whether a variable has a valid object reference. When an object variable is first created it has a 'value' of Nothing (or put more accurately, can be tested to be Nothing), and when assigned via the Set statement, it has a valid object reference. I suppose it is somewhat akin to testing a string variable for blank. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "CK" wrote in message ... What does it mean by setting an object variable to "Nothing"? Thanks!!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Thanks!!!
"Bob Phillips" wrote in message ... Hi CK, Nothing is a VB (and hence VBA) keyword that only applies to object variables, and determines whether a variable has a valid object reference. When an object variable is first created it has a 'value' of Nothing (or put more accurately, can be tested to be Nothing), and when assigned via the Set statement, it has a valid object reference. I suppose it is somewhat akin to testing a string variable for blank. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "CK" wrote in message ... What does it mean by setting an object variable to "Nothing"? Thanks!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|