Simple Problem

[Coded]

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

 

[smozgur]

May be you want a simple Error Handler:


On Error GoTo ErrHandler
If Range("B8") < 18 And _
Range("B17") > 0 Then
MsgBox "Error"
End If
ErrHandler:

 

[Legacy 98055]

What do you want your code to do if #N/A is present?
Tom

 

[Coded]

If it is #N/A i want nothing to happen, as in no msg box appearing

 

[Legacy 98055]

Then use Smozgur's code or use
On Error Resume Next
Tom