hi, i have a list of parts in a sheet.

i want the user to be able to enter a part number (this will be unique)
then excell to move to the row which holds that part number.

basically what the built in goto function does in the edit menu.

basically...

user runs macro...

input box enter the part number.....

searches for that part number......

moves to the row which holds that part number.

thanks in advance

matthew


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements