For Each c In Range("A1:A10")
If c.Text = "WHATEVER YOUR LOOKING FOR" Then
..... Do what you want here
End If
Next c

In the example change the range to whatever you want and the check
condition.

This way you have multiple check conditions within a case statement and as
each cell is returned you can manipulate each cell very easily.

"Ann" <Ann@discussions.microsoft.com> wrote in message
news:ABEFB9AF-BF85-4BDC-9290-AF9AA1AFE1B6@microsoft.com...
>I need to look through a range of cells to see if there is a match to a
> variable I have previously set. What is the syntax for referencing this
> range? Thanks.