Select Case True
case Range("A1").Value="XXX" And _
Range("A2").Value =1 And Range("A2").VAlue <=10
' do whatever
case Range("A1").Value="YYY" And _
Range("A2").Value =5 And Range("A2").VAlue <=10
' do whatever
Case . . .

Case . . .

Case Else

End Select

--
Regards,
Tom Ogilvy


"Anniem" wrote:

Hi and thanks again for any suggestions forthcoming,

Deadlines are looming and I was hoping someone could help with a formula
that goes something like:

If A1=XXX, And A2 =1, And A2<=10, do nothing. If A1= YYY, And A2=5, And
A2<=10, do nothing. (etc) If False, Message Box. There are 4 sets of
conditions to test for.

Thanks,