Finding from a range

M

Mark

I am using Excel 97.

I have a range which is named "status"

When the criteria is matched below I am wanting to place it in different
places on a spreadsheet, but it doesn't always work particularly when there
are similiarities in the team name.

For example:

If team = Range("Status").Find("Mansfield Town 2002") Then
'do something
End if

If team = Range("Status").Find("Mansfield Town 2003") Then
'do something
End if

If team = Range("Status").Find("Mansfield Town") Then
'do something
End if

Can anyone offer me some code which is a more reliable way of picking up the
correct team?

Thanks
 
M

Mike Fogleman

If team = Range("Status").Find("Mansfield Town 2002", Lookat:=xlWhole) Then

See if that narrows it down. Or try Application.WorksheetFunction.Match

Mike F
 
Top