Thanks JE,

I had to remove the period before "Range"...but other than that, it does the
trick.

Thanks again,
Paul


--

"JE McGimpsey" wrote in message
...
Simplest, perhaps:

With .Range("A1")
If (.Value) = "name1" Or (.Value = "name2") Or _
(.Value = "name3") Then
DoSomething
End If
End With


In article ,
"PCLIVE" wrote:

I'm drawing a blank on this one.

I need an IF statement in VBA that basically says, IF range("A1").value =
"name1" or "name2" or "Name3" then DoSomething.

The DoSomething code will be the same as long as A1 matches one of the
three
names.
Any help?

Thanks,
Paul