Do loops within Do loops
Yup that format is fine in general. The only problem is that it can be a
little tough to debug. That having been said there is often no good way
around it. Check to ensure that each loop has an appropriate stop condition
that can be met regardless of where it is in the processing of all of the
loops... That is usually were the problem is and you end up in an infinite
loop.
HTH
"Linking to specific cells in pivot table" wrote:
Hi - I've written code that has 1 loop within another loop that is within yet
another loop - looks something like this:
Do
Do
Do
Loop
Loop
Loop
It is not working though...just wanted to know if in theory a loop of this
sort should work (assuming all other coding is correct).
Thanks!
|