Folks €“
Im working to answer my own question in a posting yesterday, Subject:
Add/Update data stored in another worksheet 7/7/2009 2:09 PM PST, (Shameless
Bump).

The first step in resolving my issue is to identify if a part number in
sheet 1 €œTSCREEN€� range A11:A24 is in the range A:A in sheet2 (TDATA). I
found the following code in another post which gets me close. Im wondering
if I can use either a named range or cell reference within the match function
rather than actually listing the specific part name in the code.

Dim R As Variant 'could be an error
Dim Trange As Range
Set Trange = Sheets("TDATA").Range("A:A")
R = Application.Match("axle", Trange, 0)
If IsError(R) Then
MsgBox "not found"
Else
MsgBox "found"
End If

Any help is much appreciated - mike