R = Application.Match(Range("axle"), Trange, 0)

it is still a range

--
__________________________________
HTH

Bob

"Mike G - DC" wrote in message
...
Folks -
I'm 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. I'm
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