If Not c Is Nothing Then


G

Guest

I've been around Excel for a number of years, but am new to VBA. I recently
came across the code "If Not c Is Nothing Then". Could someone explain to me
what this means...the double negative throws me.
 
Ad

Advertisements

G

Guest

c is going to be an object of some sort. One possiblity is c is going to be a
range object (a range is a cell or group of cells on one sheet. Being that c
is an object until it has been "Set" to something it will be "Nothing". Once
it is set then it essentially points at a range. One common use for checking
for nothing is when you do a "Find" operation. If nothing is found then the
range object is still nothing. Now you check the c to determine if it is
nothing, or if it points to the found cell.
 
J

Jim Cone

If True Then '(will execute)
If False Then '(will not execute)

c is nothing evaluates to either True of False
c would be an object variable.
c will be nothing until it has been assigned an object.
c is nothing = True if no object is assigned to it.
c is nothing = False if has been assigned an object.

"Not" reverses a Boolean designation.
Not True = False
Not False = True

Not c is nothing returns either True or False and the
"If" statement executes if c has been assigned to an object.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"iron" <iron@discussions.microsoft.com>
wrote in message
I've been around Excel for a number of years, but am new to VBA.
I recently came across the code "If Not c Is Nothing Then".
Could someone explain to me what this means...the double negative throws me.
 
Ad

Advertisements

B

Bob Phillips

It is the same as

If c Is Something Then

which unfortunately is not valid code.

It is testing if the previous action was successful in creating an object,
or whether it failed.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 

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

Is Nothing 4
Nothing? 2
Not Nothing 5
Date to nothing 3
if range=nothing then 2
If nothing found ... 3
replacing , with nothing ? 2
Range is nothing 6

Top