The best way is to use brackets to isolate the conditions.

   If (A And B) Or _
       (C And D) And _
       (E Or D) Then
       'do you stuff
   End If

Note though that VB does not short circuit when testing, which can cause
problems, which are invariably worse, more likey, harder to debug with such
conditions. This means that even if a condition is met that would cause the
overall test to fail, it still runs the other tests. If they could give rise
to errors, you will get the error even if that test is irrelevenat in a
particular case.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

Sub M()
Dim i, j, k As Integer
i = 1
j = 2
k = 3
   If (i = 1 And j = 2) Or k = 3 Then
   MsgBox ("true")
End If
End Sub
____________________________
Gary's Student