You must put the smaller value on the left of the "To" keyword and the
larger value on the right...

Select Case Delta1ToSP
Case -0.05 To -0.02 ' This is where I expected the stop
Stop
Case -0.050001 To -0.1
Stop
Case -1 To -0.10001
Stop
Case 0.02 To 0.05
Stop
Case 0.050001 To 0.1
Stop
Case 0.10001 To 1
Stop
Case Else
Stop
End Select

--
Rick (MVP - Excel)



"David" wrote in message
...
Hello Group,

I have a select case that is not working as I expected, Delta1ToSP =
-3.38629648094637E-02 or -.0338:

Select Case Delta1ToSP
Case -0.02 To -0.05 ' This is where I expected the stop
Stop
Case -0.050001 To -0.1
Stop
Case -0.10001 To -1
Stop
Case 0.02 To 0.05
Stop
Case 0.050001 To 0.1
Stop
Case 0.10001 To 1
Stop
Case Else
Stop
End Select

What am I missing?

Thanks,
--
David