FINDing data only in one column
 

Instead of"

Cells.Find

use:

Columns(1).Find

--

Vasant


"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