Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select case error
To evaluate multiple conditions i am using select case statement. But it
gives error message if the cell contains "#n/a" value. It is not evaluating else condition. In the below example the cell (a,2) value changes to 20 if the curcell value = #n/a How to achieve this? and also how to use multiple conditions in the below statement for eg. case is 50 and less than 60 Select Case curcell.Value Case Is 50 Cells(a, 2) = 10 Case Else Cells(a, 2) = 20 End Select |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Case without Select Case error problem | Excel Discussion (Misc queries) | |||
End Select without Select Case, Block If without End If errors | Excel Programming | |||
Why Error Message "End Select without Select Case"? | Excel Programming | |||
Hopefully simple Select Case error | Excel Programming |