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