FINDing data only in one column
 

Change Cells to Columns(1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mr B" wrote in message
...
How can I use the Find command to have Excel saerch for a string but to
only look in the A column and not in any other column?

I'm currently using this statement:

Range("A1").Select
Cells.Find(What:=Worksheets("Front_End").Range("C6 ").Value,
After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:= _
False).Activate

I'm not sure what searching byrows vs cybolumns does, but I really want it
to ONLY look in the A column and if it doesn't find it there, then to stop.

Thanks