![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
Board Regular
Join Date: Mar 2002
Posts: 60
|
I have more than one Do Until loops in a subroutine. They are in series (ie not nested). It seems to be confusing the intermediate Loop statements. How do I associate a particular Loop statment with a particular Do Until statement?
Mechanic |
|
|
|
|
|
#2 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Sydney, Australia
Posts: 2,908
|
Hi,
Can you post your code? Do Loops can appear confusing when nested in other Do Loops but I'm not sure if the code itself will get confused. It's hard to say what your problem is without seeing the code. Dan |
|
|
|
|
|
#3 |
|
Board Regular
Join Date: Mar 2002
Posts: 60
|
Unfortunately I can't post my code. My Do Until loops are not nested. Perhaps I'm not intrepreting the error correctly. It tells me I have a "loop without a do statement". What I have are two sequential Do Until/Loop loops.
Mechanic |
|
|
|
|
|
#4 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Monterrey, Mexico
Posts: 1,433
|
Without your code it will be very hard to troubleshoot your problem. Make sure that your synatx is correct. Make sure you don't have an extra "loop" or "do" floating around or a multi line if statement without an end if or a "for" loop without a "next".
__________________
Kind regards, Al Chara |
|
|
|
|
|
#5 |
|
Board Regular
Join Date: Mar 2002
Posts: 60
|
I think I found it. I have a complicated If structure that wasn't correct.
Thank you, Mechanic |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|