Simple Problem

Coded · Apr 21st, 2002, 04:59 AM

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 · Apr 21st, 2002, 05:57 AM

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:

Tom Schreiner · Apr 21st, 2002, 05:57 AM

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

Coded · Apr 21st, 2002, 07:27 AM

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

Tom Schreiner · Apr 21st, 2002, 08:12 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 21st, 2002, 04:59 AM	#1
Coded New Member Join Date: Mar 2002 Posts: 5	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 ]

Apr 21st, 2002, 05:57 AM	#2
smozgur BatCoder Join Date: Feb 2002 Location: Turkey Posts: 764	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:

Apr 21st, 2002, 05:57 AM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	What do you want your code to do if #N/A is present? Tom

Apr 21st, 2002, 07:27 AM	#4
Coded New Member Join Date: Mar 2002 Posts: 5	If it is #N/A i want nothing to happen, as in no msg box appearing

Apr 21st, 2002, 08:12 AM	#5
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Then use Smozgur's code or use On Error Resume Next Tom