+ Reply to Thread
Results 1 to 4 of 4

Having trouble getting the Next value

  1. #1
    Registered User
    Join Date
    04-12-2019
    Location
    Dallas
    MS-Off Ver
    2016
    Posts
    64

    Having trouble getting the Next value

    I am trying to write a code that will grab values down the column, but if column H has already updated I want it to go to the next value and stop the if. Here is what I currently have, but keep getting an error about Next.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Having trouble getting the Next value

    Not sure why you have 3 loops, especially as the first (for each c) isn't doing anything.
    You could replace the 3 loops with 1 like
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-12-2019
    Location
    Dallas
    MS-Off Ver
    2016
    Posts
    64

    Re: Having trouble getting the Next value

    That work perfectly, Thank you.

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Having trouble getting the Next value

    You're welcome & thanks for the feedback

+ 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. Trouble with #N/A
    By sesg3c in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-12-2018, 04:13 PM
  2. [SOLVED] Trouble using 'Is Not Nothing'
    By EverGreen1231 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-22-2016, 10:55 AM
  3. [SOLVED] Trouble with 0
    By Eric McGehee in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 01-29-2015, 05:26 PM
  4. Having trouble with Sum IF
    By DuWayne in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-21-2013, 11:44 AM
  5. Trouble with API
    By pasteis in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-03-2012, 01:34 PM
  6. Im in trouble!!! Please Help!! JS
    By JimmyS in forum Excel General
    Replies: 1
    Last Post: 06-19-2005, 06:05 PM
  7. still having trouble with this....
    By nick in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-13-2005, 04:06 PM

Tags for this Thread

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