Case select returning error when cell contains #N/A : how must i avoid this error

[Luc]

Title says it all

Thanks,

Luc

 

[Gary Keramidas]

maybe this will do what you want

Sub test()
If Not IsError(Range("C1").Value) Then
Select Case Range("C1").Value
Case 1
MsgBox "1"
Case 2
MsgBox "2"
End Select
End If
End Sub

 

[Luc]

Thanks for your help !!!!!

Luc

maybe this will do what you want

Sub test()
If Not IsError(Range("C1").Value) Then
Select Case Range("C1").Value
Case 1
MsgBox "1"
Case 2
MsgBox "2"
End Select
End If
End Sub

--


Gary Keramidas
Excel 2003