VBA tells me I have a Loop without a Do, but I'm not sure where the problem lies.

Hi all, simple question, I believe. I've written this macro

Please Login or Register  to view this content.

And I keep getting the same error: "Loop without Do"

So I'm assuming that something inside that Do is closing it but I don't know enough about VBA to know what that could be. Could somebody illuminate that for me?

Thank you very much in advance.

I'm not sure why the compiler is highlighting the "loop without do". What I see is a For Each without a Next. My guess is that, because the For Each is nested inside of the Do...Loop, the compiler is confused as to the source of the error.

I put a Next CodInd statement just before the Loop Until statement, and the procedure compiled just fine.

Unless the next issue is closely related to this one, then this forum tends to prefer that you start a new topic for each question.