vba LookA:t::=

[oldjay]

Using Cells.Find
Can't seem to find any other options for x1Whole in.

LookAt:= _
xlWhole

As I have it now, you must type in the whole word or words
to find a customer in a long list. I want to type in the
first couple of letters to get near the customer entry

 

[Frank Kabel]

Hi
LookAt:= xlPart

 

[Don Guillett]

try
Sub findclose()
x = Columns("e").Find("thh", lookat:=xlPart).Row
MsgBox x
End Sub

 

[Guest]

Hi Thanks but "Part" finds any cell that have the letters
I type. I want to find the cell with the first few letters
in the right order
if I want to find "co" and the list has Comstat and Botco
in it I dont want to find the Botco

oldjay

 

[Frank Kabel]

Hi
don't see a chance to accomplish that ith the Find method

 

[Don Guillett]

Then this might??? help

Sub findclose1()
For Each c In [e1:e12]
If Left(c, 2) = "Th" Then Cells(c.Row, 1).Select
Next
End Sub