Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. -- HTH... Jim Thomlinson "iron" wrote: 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. |