VBA select case question
 

Hi,

I have a select case statement and for one case I want the value to be
between 250,000 and 1,000,000

SO I wanted something like

Select Case XXX

Case Is 250,000<XXX<1,000,000

but this was not working does anyone know the way to do this?

Thanks for your help

VBA select case question
 

On Wed, 25 Jan 2006 10:05:03 -0800, "Jeff"
wrote:

Hi,

I have a select case statement and for one case I want the value to be
between 250,000 and 1,000,000

SO I wanted something like

Select Case XXX

Case Is 250,000<XXX<1,000,000

but this was not working does anyone know the way to do this?

Thanks for your help

Case 250000 to 1000000


--ron

VBA select case question
 

if xxx 250000 AND xxx < 1000000 then

end if


"Jeff" wrote:

Hi,

I have a select case statement and for one case I want the value to be
between 250,000 and 1,000,000

SO I wanted something like

Select Case XXX

Case Is 250,000<XXX<1,000,000

but this was not working does anyone know the way to do this?

Thanks for your help