Closing loop
Please Login or Register to view this content.
Hi,
The above code is required to end running after j reaches to 100 and i reaches to 300, but even after i=300 & j=100 the code again operates from the begining.
Are there any modifications to be done for the code to stop Lopping, after reaching the maximum values of i & j?
Thank you
I don't think it will go beyond the defined loop counter
Your code should run as you describedPlease Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
yes it runs , that is fine, but it runs twice starting again from the beginning which is the major problem.
how are you starting the code?
Josie
if at first you don't succeed try doing it the way your wife told you to
The code is coded below . The only thing i`am after is to end that "for" statement.
how are you running it? button? f5? macros dialog?
that code will only loop as you described unless you run it twice.
iam running the code using RUN button in VB
How to exit "FOR" & or "Next" After the Loop has run once?
you use exit for or exit sub depending what you want to do but that code will only run the two loops once unless something else is calling it again like a change event or beforesave
no need to go after all those problematic solutions, instead I did added 200 to "i" , which proved as a short & powerful desired solution,
Anyways thanks to everyone participating in solving my Problem.
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks