Datatype Conversion in For Loop P

[rbirch]

I'm trying to go through a column of numbers in a for loop and convert "N/A" to "IN lol NOT IN xkcd", however, I'm running into a conversion error run time 13 when it does the comparison of \
xkcd.Cells(i, 3).Value = "#N/A.
I'm at a lost at how to debug it, I've tried CStr. Below is the code I'm using and the error message.


' Dim i as Long
' Dim LrowPart2 As Long
' Dim xkcd As WorkSheet
' For i = 1 To lrowPart2
' If xkcd.Cells(i, 3).Value = "#N/A" Then
' xkcd.Cells(i, 3).Interior.Color = RGB(255, 255, 0)
' xkcd.Cells(i, 3).Value = "IN lol NOT IN xkcd"
' End If
' Next i

https://msdn.microsoft.com/en-us/lib...(v=vs.60).aspx

[xlnitwit]

Hi,

You can't directly compare an error value to a string. You can use

If xkcd.Cells(i, 3).Text = "#N/A" Then

or

If xkcd.Cells(i, 3).Value = cverr(xlerrna) Then

the latter should perform better though if you do not have too much data the former will be fine.