If you object to the Not, you have a couple of other options:

If S = "A" or S = "D" Then
'leave empty or put there the code that would
'ordinarily follow the End If
Else
'error message
Exit Sub
End If

If S < "A" and S < "D" Then



On Sun, 10 Aug 2003 09:45:24 -0400, "David McRitchie" wrote:

I don't understand the explanation, but I think by splitting the
code David meant that he can see more of the other code
on the screen with less scrolling when fewer lines are used
for the test. Why else would one want to test for a negative
(NOT) conditions when positives are generally easier to read
and less confusing..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"David Turner" wrote in message
...
Myrna Larson wrote

I don't understand what you mean by "split my code". How does the
Select Case block differ from an If/End if block in this situation?

All code following a valid Column entry would take the place of Chip's
MsgBox "entry OK" and the Case Else would follow that. Not True?

If Not (S = "A" or S = "D") Then

I like it.

Thanks for jumping in.

--
David