If statement and string - how

[earp_]

Hi,
I have this

If ((Sheets("Sheet1").Range("B11")) = "#N/A") Then

but it gives me an error on that line.
I want to say:
if B11 is equal to the value #N/A do something.
How?

 

[mikerickson]

If ActiveCell.Value = CVErr(xlErrNA) Then MsgBox "Is #N/A error"

 

[earp_]

thanks

 

[xld]

If Sheets("Sheet1").Range("B11").Text = "#N/A" Then

 

[jindon]

If Sheets("Sheet1").Range("B11").Text = "#N/A" Then

Will not work when column is too narrow and showing as ###, istead of #N/A.

 

[earp_]

I can always put "or ###"

That's better thanks

 

[xld]

I can always put "or ###"

That's better thanks

Not a good idea. Will it be 1, 2 or 3 #s. If you know the #N/A is caused by a lookup failure not hard-coded, Mike's solution will work. But will the columns really be that narrow? I doubt it.

 

[earp_]

exactly.