Cells.find Help

DennisG · #1 (**permalink**) 06-05-07, 11:50

I have defined FN = to a file id. What I am trying to do is use Cells.find(What:=FN etc... instead of Cells.find(What:="1234" etc... Because I will have to find approx. 2K records against 38K. I originally took 1 records from the 2K and looped it through the 38K to find a match however its taking to long. When I use the FN it does not find the value in my sheet even though I am only using 3 records against 1. Any help would be great. Thanks

MikeTheBike · #2 (**permalink**) 06-06-07, 09:13

Hi

I think you will have to give a little more info on what you have at present
ie is it anything like this

Code:

    Dim FN As Long
    FN = 123
    Cells.Find(What:=FN, After:=ActiveCell, LookIn:=xlValues, LookAt:= _
        xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
        , SearchFormat:=False).Activate
    Cells.FindNext(After:=ActiveCell).Activate

If not please give example and/or more explanation.

MTB

Internet Services

Web Development

Digital Marketing

Consumer Tech