Have a look at the Find Method in help.
--
Damon Longworth
Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com
"dave91" wrote in message
...
using vba in excel 2000, wish to search a column for specific data and
return
that value to another cell.
can do this using vlookup but wish to use vba