+ Reply to Thread
Results 1 to 5 of 5

Inconsistent Cells.Find Results

  1. #1
    Registered User
    Join Date
    05-26-2010
    Location
    Kentucky
    MS-Off Ver
    Excel 2010
    Posts
    31

    Inconsistent Cells.Find Results

    I've got a macro that searches a column for a particular value. Below is an excerpt of the code

    The code works...sort of. On sheet ws, I have an alphabetized list of names. The macro goes through that list, row by row, and compares it to a list on sheet ge (which is also alphabetized).

    The problem is that I have two nonconsecutive names in ws that do appear in the ge list. However, the macro only spits out the first match, but not the second. I've confirmed that if I use MATCH() in a cell, both names return a positive result. I'm guessing its something in the way I'm calling Find, but I'm not sure where I'm going wrong.

    Thanks for looking!


    Please Login or Register  to view this content.
    Last edited by GordonPSmith; 12-24-2011 at 12:36 AM.

  2. #2
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Inconsistent Cells.Find Results

    Try
    Please Login or Register  to view this content.
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

  3. #3
    Registered User
    Join Date
    05-26-2010
    Location
    Kentucky
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Inconsistent Cells.Find Results

    Looked promising, but it's still only catching the first entry.

  4. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: Inconsistent Cells.Find Results

    Pl try this code


    Please Login or Register  to view this content.
    Last edited by kvsrinivasamurthy; 12-21-2011 at 04:59 AM.

  5. #5
    Registered User
    Join Date
    05-26-2010
    Location
    Kentucky
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Inconsistent Cells.Find Results

    Thanks for the help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1