Why is this causing error??

[ogo]

Just see the code below it throws run-time error 13:Type mismatch. I feel very strange, why can't we compare value in cell when it is #N/A Can anyone explain why is this?

Sub test()
MsgBox Cells(1, 1).Value
Sheet2.Cells(1, 1).Value = "#N/A"
If Sheet2.Cells(1, 1).Value = "#N/A" Then
MsgBox "iN TRAP"
End If
End Sub

Thanks,
Ogo

 

[repairman615]

Hello,

Try like this with .text:

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> test()<br>MsgBox Cells(1, 1).Value<br>Sheet2.Cells(1, 1).Value = "#N/A"<br>    <SPAN style="color:#00007F">If</SPAN> Sheet2.Cells(1, 1).Text = "#N/A" <SPAN style="color:#00007F">Then</SPAN><br>        MsgBox "iN TRAP"<br>    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN><br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

 

[ogo]

This works fine, thank u very much..

Ogo