Databases
StackOverflow2013
Postsdbo
POexit a nested loop in excel
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POexit a nested loop in excel
    primarykey
    data
    text
    <p>i have a loop in a macro i'm writing of the following structure:</p> <p>there are two worksheets in this book. raw data (hence the endpointData variable) and a G/L (General ledger) sheet (hence the endpointGL variable)</p> <p>there are three <code>for</code> loops in this function: </p> <p>(1) the first loop iterates through each record in the raw data file. <br> (2) the second loop iterates through the verified matches from <code>REGEXP</code> (a regular expression search) and <br> (3) the third loop goes through the G/L and finds a corresponding match and puts (using: <code>PUT_DATA_RANGE</code>) that data into the appropriate spot. </p> <p>Here's sort of what i'm getting at:</p> <p>psuedocode:</p> <pre><code>For i = 2 To endpointData If SOME_TEST = True Then Set MATCHES = REGEXP.EXECUTE() For Each myMatch In MATCHES For j = 1 To endpointGL If myMatch.value = SOME_CONDITION Then PUT_DATA_RANGE Exit For ElseIf myMatch.value &lt;&gt; SOME_CONDITION Then MsgBox ("there might be a problem") ' EXIT BOTH LOOPS HERE ' write handler code Next End If Next End If Next i </code></pre> <p>now you'll notice that i have a few comments to myself. if the third loops finds no match in the G/L the code currently interrupts to notify the user. but that message box <code>MsgBox("there might be a problem")</code> is looped through along with the third loop. how do i get excel to exit BOTH loops and bring the FIRST for loop to the next availabe record in the raw data? </p> <p>by the way, i've tried exiting it with an <code>Exit For</code> but that doesn't seem to work exactly. </p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USfranklin
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POexit a nested loop in excel
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POexit a nested loop in excel
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POexit a nested loop in excel
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload