Check if value exists in range without looping
<p>I'm used to python syntax where to check if <code>7</code> is in <code>list1</code> you simply type <code>7 in list1</code> and it returns a boolean. How can I perform something like this in vba?</p>

<p>I'm currently looping through a large range.  I want to occasionally check if a value i'm looping over is in a different range.  This could get much slower if I had to nest more loops into my loops.  What's the fastest way to approach this problem?</p>

<pre><code>For i = 400 To 1 Step -1:
'doing other things

'here's some psuedo-code of what I want to do
If Sheets("Sheet2").Cells(i, 2).Value In Sheets("Sheet1").Range("NamedRange")
Sheets("Sheet2").Cells(i, 2).EntireRow.Delete
End If

Next i
</code></pre>