This may help
http://www.ozgrid.com/VBA/advanced-find.htm

--
Steve

"JackGombola" wrote in message
...
I have an Excel 2003 spreadsheet with Lastname Firstname and Teamname as
columns A-C. The sheet is sorted on these three columns in the order
stated.
Columns D thru T contain other teamnames played.

I am writing a macro that put's up an InputBox requesting the user to
enter
a Lastname, Firstname, Teamname separated by commas such as:
Lastname2,Jill,Team1 to find the row for "Jill Lastname2".

I used the macro recorder to create a macro that does a Find on Col A then
B
then C. Problem is, when I find the Lastname in Col A then select Column
B
and issue a Find command for the Firstname, the Find starts from the top
of
column B when I want it to begin with the row that contained the lastname
successfully found in column A. There is an After: property associated
with
the Find command but I don't know how to assign the row number where the
lastname was found to that After: property.


Sample Data

Lastname1 Jill Team1
Lastname2 Jill Team1
Lastname2 Mary Team1

When I enter "Lastname2,Jill,Team1" the first Find in my macro
successfully
finds row 2, but the next Find stops at the Jill name in Column B
identifying
the wrong row.

Any and all help is appreciated.

Jack