Select Case Question

[brans1982]

Hi,

How do I use the 'Or' function in Select Case? e.g

Select Case Cells(2,1)

Case "A" Or "B"

MsgBox"Test"

End Select

Thanks.

 

[Lewiy]

Just use a comma

Select Case Cells(2,1)
  Case "A","B"
      MsgBox "Test"
End Select

 

[brans1982]

Dammit!

I'm having brian freeze today!

Thanks!