View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Damon Longworth Damon Longworth is offline
external usenet poster
 
Posts: 111
Default search column for a specific piece of data using vba

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