Another basic question... CASE with a range
 

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

Another basic question... CASE with a range
 

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

Another basic question... CASE with a range
 

Phillips,

what do you want q to be if
a is equal to and greater than x and if a is less than z
AND
a is equal to and greater than b and if a is less than c
AND
a is equal to and greater than e and if a is less than f?

Henry

"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

Another basic question... CASE with a range
 

Select Case True
Case a = x and a < z
q = 1
Case a = b and a < c
q = 2
Case a = e and a < f
q = 3
Case else
q = 0
End Select

--
Regards,
Tom Ogilvy


"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