Posted to microsoft.public.excel.programming

David

external usenet poster

Posts: 1,560

Select Case

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Case not recognized in Select Case	kevlarmcc	Excel Programming	4	March 29th 10 07:40 PM
Select Case	Ken[_4_]	Excel Programming	1	January 26th 09 03:56 PM
Case without Select Case error problem	Ayo	Excel Discussion (Misc queries)	2	May 16th 08 03:48 PM
End Select without Select Case, Block If without End If errors	Atreides	Excel Programming	12	November 17th 06 05:10 PM

All times are GMT +1. The time now is 07:58 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us