Have a look in vbe HELP index for Select


--
Don Guillett
SalesAid Software

"Phillips" wrote in message
news:ZKNub.249379$Fm2.259879@attbi_s04...
How would I do the following? I can not find anything about AND/OR in the
VBA help file...


if a is equal to and greater than x and if a is less than z
q=1

if a is equal to and greater than b and if a is less than c
q =2

if a is equal to and greater than e and if a is less than f
q=3

otherwise

q = 0

etc...

Thank you
Phil