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