Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to jump cells in column data when finding average, max and mi | Excel Discussion (Misc queries) | |||
Finding multiple data values in a column | Excel Worksheet Functions | |||
FINDING AND LISTING UNIQUE DATA IN A COLUMN | Excel Worksheet Functions | |||
Finding data in a text column | Excel Discussion (Misc queries) | |||
Finding last cell with data in a column | Setting up and Configuration of Excel |