Thread: Nothing?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
CK CK is offline
external usenet poster
 
Posts: 5
Default 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!!!