Results 1 to 4 of 4

Question about "DO UNTIL" loop in VBA

Threaded View

  1. #1
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Red face Question about "DO UNTIL" loop in VBA

    Hello guys and girls,

    I use a "do until" loop to get certain data out of a long string (a website responsetext).
    Now I use the following :

    Do Until IsNumeric(Mid(polres, x, 1)) = True
    x = x + 1
    Loop
    This is fine, but I need to add something, so basically I want to say the following (but that doesn't work) :
    Do Until IsNumeric(Mid(polres, x, 1)) = True OR Until Mid(polres, x, 1) = "-"
    It seems I cannot use "OR" in DO UNTIL loops. This surprises me, because I can use "AND" (I use that in another occassion), but here that won't work.

    Anyone has any good suggestion on how to go about this?

    Thanks!
    Last edited by JasperD; 09-24-2013 at 05:15 AM. Reason: typo
    Please click the * below if this helps

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Beginner question on "For Next" loop.
    By MarioK07 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-05-2013, 03:53 PM
  2. [SOLVED] Loop to check for "yes" then copy the IDs with "yes" and paste to other workbook
    By Hallet in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-11-2012, 12:41 PM
  3. question about for" do.....loop "for multiple worksheets task
    By anaking in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-16-2010, 11:31 AM
  4. VBA "For Loop" Question
    By wingfield in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-26-2006, 01:10 PM
  5. "Loop until" syntax question
    By Fastbike in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-03-2005, 10:16 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1