+ Reply to Thread
Results 1 to 5 of 5

VBA find on hit go to next row

  1. #1
    Registered User
    Join Date
    12-09-2009
    Location
    Belgrade
    MS-Off Ver
    Excel 2010
    Posts
    17

    VBA find on hit go to next row

    I made a simple loop to go trough worksheet and to print multiple hits for .Find in a Range
    Right now my code displays all cells containing any data in it.

    What I would like is:
    when there is a HIT to continue with .FindNext but to skip to next row

    This is my sample table:
    NAME VALUE 1 VALUE 2 VALUE 3
    WORKER 1 somethinW1.1 somethingW1.2
    WORKER 2 somethingW2.2 somethingW2.3
    WORKER 3 somethingW3.1 somethingW3.3
    WORKER 4
    WORKER 5 somethingW5.2

    This is my VBA code:
    Please Login or Register  to view this content.
    My Immediate window displays result like this:
    Please Login or Register  to view this content.
    I need somethin like this:
    Please Login or Register  to view this content.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: VBA find on hit go to next row

    Well - it's not pretty:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    12-09-2009
    Location
    Belgrade
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: VBA find on hit go to next row

    it works if I put it like this

    Please Login or Register  to view this content.

  4. #4
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: VBA find on hit go to next row

    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  5. #5
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: VBA find on hit go to next row

    All that work and we could have just changed the original find line to:

    Please Login or Register  to view this content.
    Thanks for the rep!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find pattern in different sets of similar data and compare/find the closest ones.
    By Sarangsood in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-16-2020, 09:46 AM
  2. Replies: 3
    Last Post: 01-15-2019, 03:58 AM
  3. Replies: 1
    Last Post: 04-10-2017, 03:33 PM
  4. Replies: 3
    Last Post: 08-18-2015, 09:04 AM
  5. Replies: 9
    Last Post: 12-21-2014, 06:29 PM
  6. Replies: 4
    Last Post: 09-18-2012, 10:54 AM
  7. Replies: 1
    Last Post: 01-31-2006, 06:25 PM

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