Results 1 to 2 of 2

Thread: Cells.find Help

  1. #1
    Join Date
    Sep 2005
    Posts
    23

    Unanswered: Cells.find Help

    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

  2. #2
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •