View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Auric__ Auric__ is offline
external usenet poster
 
Posts: 538
Default Condition Statement

On Tue, 9 Dec 2003 00:46:05 -0800, Stel wrote:

Wonder if you can help me on this:

I'm writing more than 4 conditional statement in one loop:

If =Bear Then
If =Blue Then return
If =Red Then return
If <Bear Then
If =Yellow Then return
....

The problem is that =Red condition keeps returning true even under <Bear
i.e. 'Red' keeps showing up no matter what
Why is that?


Your problem is unclear. We need more info - what is equal to Red? To
Bear? To Blue and Yellow? Can you perhaps post the actual code
containing this chunk so we can see it in context?
--
auric "underscore" "underscore" "at" hotmail "dot" com
*****
There is no XXXXXXX place for censorship!