Using "Case .. To"
 

Hi everyone,

Say I have a VB piece of code like this:

Case 3.45 To 4.44: Num = 40

Can't I replace the "3.45" with a cell location so I can be able to
vary the value when needed?

I tried this: Case "h35" To "i35": Num = 40

No complaint by the VB compiler, but the code wasn't performing well!

Thanks,
Mike

Using "Case .. To"
 

Case Range("h35").Value To Range("i35").Value : Num = 40

--
Regards,
Tom Ogilvy

"Mike" wrote in message
ups.com...
Hi everyone,

Say I have a VB piece of code like this:

Case 3.45 To 4.44: Num = 40

Can't I replace the "3.45" with a cell location so I can be able to
vary the value when needed?

I tried this: Case "h35" To "i35": Num = 40

No complaint by the VB compiler, but the code wasn't performing well!

Thanks,
Mike