View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
 
Posts: 983
Default 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!