Difference between If, Then ActiveCell vs If, Or, Then ActiveCell

[Panda2490]

Hello,

Beginner at VBA here. Was wondering if someone could simply explain to me what the differnece is between:
If ActiveCell = " " Then ActiveCell = 0
Else ActiveCell.Offset(1,0).Select

V.S.

If ActiveCell = '' Or ActiveCell = " "
Then ActiveCell = 0
Else ActiveCell.Offset(1,0).Select

Thanks you!

 

[Norie]

I'm afraid neither set of code will compile so I'm not sure how they can be compared.

Is this perhaps what you wanted to compare?

If ActiveCell = " " Then
    ActiveCell = 0
Else
    ActiveCell.Offset(1, 0).Select
End If

' VS

If ActiveCell = "" Or ActiveCell = " " Then
    ActiveCell = 0
Else
    ActiveCell.Offset(1, 0).Select
End If

If it is then the only difference is the second If statement is checking if the active cell is empty or contains a space.