On Aug 22, 2006, at 10:00 AM, Terry Ford wrote:
The following will work:
Select Case Y
Case Is <100
startY = 0
endY = 100
Case Is <200
startY = 100
endY = 200
etc.
One thing I should mention is the original question showed:
Select Case Y
Case Is < 100 // Was: Y < 100 // Row #1
startY = 0
endY = 100
Case Between(Y,100,200) // Was: Is > 100 And Is < 200 // Row #2
startY = 100
endY = 200
Besides the word Between not being valid, if changed to an
If...ElseIf... statement:
If Y < 100 Then
startY = 0
endY = 100
Else If Y > 100 and Y <200 Then
startY = 100
endY = 200
Else If Y > 200 and Y <300 Then
startY = 200
endY = 300
etc.
will not evaluate 100, 200, etc.
Terry
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
