Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Case select returning error when cell contains #N/A : how must i avoid this error
Title says it all
Thanks, Luc |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Case select returning error when cell contains #N/A : how must i avoid this error
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 "Luc" wrote in message ... Title says it all Thanks, Luc |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Case select returning error when cell contains #N/A : how must i avoid this error
Thanks for your help !!!!!
Luc "Gary Keramidas" <GKeramidasAtMSN.com schreef in bericht ... 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 "Luc" wrote in message ... Title says it all Thanks, Luc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use of Case-Select, with on error | Excel Programming | |||
Case without Select Case error problem | Excel Discussion (Misc queries) | |||
Syntax Error ?. Execution does not enter the Select Case | Excel Programming | |||
select case error | Excel Programming | |||
Hopefully simple Select Case error | Excel Programming |