Comparing

Is Operator

When comparing objects use "IS" and not "=" or "<>".
To compare two objects you should use the "IS" operator
This can be used for comparing objects
This operator is supposed to determine whether two variables refer to the same object but unfortunately it does nor always work.

Do While Not object Is Nothing 
Loop 

IsNot

This is not available in VBA (only VB.Net)