Nothing?

B

Bob Phillips

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)
 
C

CK

Bob Phillips said:
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)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

set Object = Nothing 4
Nothing Keyword Destories Objects rather than just resetting the variable to an empty variable 22
cell selection, merging..... 1
Testing an object varible for Nothing 5
User Agent to get source code 1
For Each Type mismatch 5
My macro doesn't work if sheet is protected but it works if not protected 2
Find and FindNext...from Excel VBA Help generates 91 error. 11

Top