Solved: If Statement Insanity

[magelan]

What is wrong with this IF statement?

[vba]
If Not ((UCase(countryRange.Value) = "US") Or (UCase(countryRange.Value) = "PR") Or (UCase(countryRange.Value) = "VI") Or (UCase(countryRange.Value) = "GU")) Then ' if not US or PR or GU or VI
Debug.Print countryRange.Value
[/vba]
This is getting a lot of rows returning saying "US" even though the IF statement explicitly catches the US country code..What am I doing wrong?

[magelan]

Nevermind, i forgot to Trim the variable i was checking...

[mikerickson]

This syntax might be more readable

[VBA]Select Case UCase(countryRange.Value))
Case "US", "PR", "VI", "GU"
' do nothing
Case Else
Debug.Print countryRange.Value
End Select[/VBA]