Im using this code :
If Range("B8")< 18 And _
Range("B17") > 0 Then
MsgBox "Error"
End If
End Sub
but sometimes B8 is #N/A and therefore i get the 'run time error 13'. Anyway i can make this stop happening?
cheers
This message was edited by Coded on 2002-04-21 04:12
If Range("B8")< 18 And _
Range("B17") > 0 Then
MsgBox "Error"
End If
End Sub
but sometimes B8 is #N/A and therefore i get the 'run time error 13'. Anyway i can make this stop happening?
cheers
This message was edited by Coded on 2002-04-21 04:12