Receiving Runtime Error 424 Object Required from Enumerable.Contains

[rubberduck203]

Enumerable.Contains

This code causes Runtime Error 424.

For Each cell In Range("C3:C8056")
     If Not (e.Contains(cell.Value)) Then
         columnD.Add (cell.value)
     End If
 Next cell

Can be worked around by using compareByDefaultProperty option.

For Each cell In Range("C3:C8056")
    If Not (e.Contains(cell, True)) Then
        columnD.Add (cell.value)
    End If
Next cell

[malachi26]

I didn't implement the feature properly

For Each cell In Range("C3:C" & lastCRow)
    If Not (e.Contains(cell.value, True)) Then
        columnD.Add (cell.value)
    End If
Next cell

if I call Contains(cell.value, True) it works properly as long as I don't try to pass a null cell to the function.