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

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

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