+ Reply to Thread
Results 1 to 9 of 9

need to run the entire list then post final result found or not found after.

  1. 06-05-2018, 04:46 AM #1
    0o0o0
    0o0o0 is offline
    Registered User
    Join Date
    10-11-2003
    Posts
    81

    need to run the entire list then post final result found or not found after.

    Ok so it cycles through top 6 ..

    just need it to "see" if certain words are in the top 5-6...

    Below does it.. but id' like it to cycle through all 5-6 ...then give the response yes its there or no its not found..

    Right now it responds..

    NOT FOUND
    NOT FOUND
    NOT FOUND
    YEP FOUND IT
    NOT FOUND
    NOT FOUND








    Please Login or Register  to view this content.
    Basically I dont want a "RINSE" and repeat more like remember and repeat and give the final result if anything was found in the 5-6 cycles.. at the very end.


    Thanks guys
    Reply With QuoteRegister To Reply
  2. 06-05-2018, 05:27 AM #2
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,864

    Re: need to run the entire list then post final result found or not found after.

    The po9st text is a bit foggy to me, but let me try to follow the thread title:

    Please Login or Register  to view this content.
    Best Regards,

    Kaper
    Reply With QuoteRegister To Reply
  3. 06-05-2018, 12:54 PM #3
    0o0o0
    0o0o0 is offline
    Registered User
    Join Date
    10-11-2003
    Posts
    81

    Re: need to run the entire list then post final result found or not found after.

    ya I had another post, but it was answered then I was adding more to it ( the above ) so i figured its a new question and posted here sorry.

    Part one https://www.excelforum.com/excel-pro...-possible.html
    Reply With QuoteRegister To Reply
  4. 06-05-2018, 01:55 PM #4
    0o0o0
    0o0o0 is offline
    Registered User
    Join Date
    10-11-2003
    Posts
    81

    Re: need to run the entire list then post final result found or not found after.

    possibly exit sub stops too quick
    Last edited by 0o0o0; 06-05-2018 at 03:22 PM.
    Reply With QuoteRegister To Reply
  5. 06-05-2018, 03:22 PM #5
    0o0o0
    0o0o0 is offline
    Registered User
    Join Date
    10-11-2003
    Posts
    81

    Re: need to run the entire list then post final result found or not found after.

    nope does nothing. Exit sub? crosses it out? not sure.
    Reply With QuoteRegister To Reply
  6. 06-05-2018, 05:36 PM #6
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,864

    Re: need to run the entire list then post final result found or not found after.

    Try:
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 06-05-2018, 10:04 PM #7
    0o0o0
    0o0o0 is offline
    Registered User
    Join Date
    10-11-2003
    Posts
    81

    Re: need to run the entire list then post final result found or not found after.

    I appreciate the help! but "Next eleRow 'rinse and repeat" just makes it do the rest again 5 then 5 then 5 then page done.
    Reply With QuoteRegister To Reply
  8. 06-06-2018, 12:58 AM #8
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,864

    Re: need to run the entire list then post final result found or not found after.

    Well, I probably misplaced messages, shall read:
    Please Login or Register  to view this content.

    But as a matter of fact, I probably don't follow your idea: "but id' like it to cycle through all 5-6"
    Reply With QuoteRegister To Reply
  9. 06-06-2018, 01:00 PM #9
    0o0o0
    0o0o0 is offline
    Registered User
    Join Date
    10-11-2003
    Posts
    81

    Re: need to run the entire list then post final result found or not found after.

    not solved but marked as solved to end this thread.


    EDIT! actually we were missing eleCol... eleCol.innerText above so yes change the required and it is SOLVED
    Last edited by 0o0o0; 06-08-2018 at 02:21 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Found?, then delete entire rows. Not found end sub
    By Andrewstupendo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-21-2018, 01:56 PM
  2. Searching column 1 with data from 2 and reporting found or not found
    By San75 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-15-2016, 05:23 PM
  3. Search for value in a range and overwrite if found and create new if not found
    By mm671750 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-04-2016, 01:19 PM
  4. [SOLVED] delete entire row when value is found
    By 9599lorenzo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-14-2015, 03:06 AM
  5. [SOLVED] delete entire row when value is found
    By 9599lorenzo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-13-2015, 06:47 PM
  6. Check for values in a table and if found add value found in column to left to list
    By robhargreaves in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-07-2013, 02:57 PM
  7. [SOLVED] Instead of showing #N/A and #REF!, i want the result show as "Not Found" and "Found"
    By DonnyLau in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-11-2013, 08:58 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1