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)





© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext