[Resolved] Excel VBA, please help

[ndtsteve]

Just one more quick question and then I will go away for a while

I have 3 conditions, call them boxes a,b and c.
Box A is a number between 6 and 8
Box B is a number between 0 and 10
Box C is either Y or N

Depending on the results of these 3 cells a vaue is taken from a table.
Short of saying If Cells(3, 32) = 6 or 7 or 8" etc, is there are number between function?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Cells(3, 32) = ""Number between 6 & 8""And Cells(7, 32) = number between 0 and 10 And Cells(9, 32) = "N" Then
Cells(50, 21) = Cells(3, 5)

End If