+ Reply to Thread
Results 1 to 2 of 2

Error handling within loop

  1. #1
    Registered User
    Join Date
    03-22-2009
    Location
    New Jersey
    MS-Off Ver
    Excel 2007
    Posts
    1

    Error handling within loop

    Hi all. I just added my first ever attempt at error handling, I used an on error goto next i(skip current block and continue with the loop). What I'm trying to do is use a loop to get data from a web query. The url string contains a date that is incremented by one day with each pass of the loop. It seems that there isn't a web page for Sundays, from what i can see, so I just want to skip them. *Code below.* It worked to get me past the first error, but is thrown again just a few passes later. Argh. Any ideas?

    Please Login or Register  to view this content.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Error handling within loop

    It might be a start to disable error handling, and debug when the code breaks to see where the errors occur other than the one you're expecting.
    Entia non sunt multiplicanda sine necessitate

+ 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