Pam,

You've left out a lot of important details, but the following might
get you going in the right direction.

Sub AAA()
Dim R As Range
Dim V As Variant
Dim S As String
S = "11,22,33" '<<<< This is the data to test against
V = Split(S, ",")
For Each R In Range("A1:A10") '<<<< This is the range with data
' put alert in next column right
If IsError(Application.Match(CStr(R.Value), V, 0)) = True Then
R(1, 2) = "no match"
Else
R(1, 2) = "match"
End If
Next R
End Sub

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
The San Diego Project Group, LLC
(email is on the web site)
USA Central Daylight Time (-5:00 GMT)




On Fri, 3 Oct 2008 08:24:04 -0700, PamG
wrote:

I need to compare cell values in a column to a comma-delimited string. The
column has ID numbers and the string consists of a comma-delimited string of
ID numbers.

Any help would be appreciated....

Thanks
Pam