I've got a question for the real experts here. Can any one of you help me understand the difference between all of these, when checking a cell for no content?
=> isnull()
=> = ""
=> isempty()
=> = null
I've been using this program for a long long time, and everytime I have to check something like this I get very annoyed because I've always run into anomalies with regard to these statements. I am currently putting together a knowledgebase for a student and one of my routines has to check a cell for no content. And to cover all the bases of Excel ""quirks"", this is the code I'm using:
    If IsNull(rstart) Or rstart = "" Or IsEmpty(rstart) Or rstart = Null Then
        lststatement.Clear
        Exit Sub
    End If
Can someone tell me why I'm not trusting Excel to be reliable? I've run into this in the past. Is it just because I'm not a professional developer and don't know every little detail about this program? In this example, rstart has been set in the code, and declared as a range object.

thanks.