Just different if the names do in fact follow a numbering pattern.

Sub Demo()
Select Case UCase([A1].Value)
Case "NAME1" To "NAME3"
MsgBox "Doing Something"
End Select
End Sub

--
Dana DeLouis


"PCLIVE" wrote in message
...
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

--