View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Paul Pedersen Paul Pedersen is offline
external usenet poster
 
Posts: 18
Default order of evaluation

Hmm, waste of processor cycles. Thanks.


"Tom Ogilvy" wrote in message
...
All conditions will be evaluated.

--
Regards,
Tom Ogilvy

"Paul Pedersen" wrote in message
...
I have a statement like this:

If condition1 Or condition2 Or condition3 Then
blah blah
End If

In situations in which condition2 will not evaluate, an error is raised
even if condition1 evaluates to True (at which point conditions 2 and 3
are irrelevant, so there's no point in attempting to evaluate them).

Is it wrong to assume that conditions will be evaluated in the order in
which they are presented?