Help with If Not ... Is Nothing

[kayza]

Hi
Since I am less so familiar with this statement, then I can not do much to do a series of tests with this statement. let's say there's a code like this

If Not X is Nothing Then

What does this code mean.
Is there anyone who can help me explain it, and give me a little example using this statement to better understand.

Thank you in advance
sorry if the thread has been discussed in this forum.

 

[RoryA]

It means basically:

If X has an Object assigned to it, then...

It is often used after a Find operation to check whether a value was found and the relevant cell was assigned to a variable.

 

[Perdafircax]

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