Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In my code below (which runs OK), when vbNo is returned from the msgbox, I
want to skip past any comp that is Premier League. Although the code runs Ok, after the first test for "Premier League" in each comp, the subsequent tests are not required - How could I restructure to make the code more efficient? PremierLeague = MsgBox("Include PremierLeague Matches?", vbYesNo) For Each comp In Schedule For Each Rownd In Range(comp) 'test for Premier league For Each Item In Range(comp & "_" & Rownd) If Left(comp, 13) = "PremierLeague" Then If PremierLeague = vbNo Then Exit For End If End If Do stuff Next Next Next -- David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Inefficient? | Excel Programming | |||
Inefficient Space Removal | Excel Programming | |||
Loop worked but is it inefficient? | Excel Programming | |||
Loop worked but is it inefficient? | Excel Programming | |||
Inefficient VBA Code - Worksheets Property | Excel Programming |