Nested For...Next Loop, Invalid Next control variable reference Error

Hi,
Im still new in VBA.
I tried to do the next iteration in the "nested for..next loop". Here is my attempt in doing it. But there's an error

Compiler complains : Invalid Next control variable reference

Could anyone help me with this?

Thanks in advance.

Please Login or Register  to view this content.

First Next j should come rite? The inner for loop is "j"..

Please Login or Register  to view this content.

i tried but there's still error.. What i'm trying to do is , when this condition "If (Sheet2.Cells(i, 18) <= Date)" met, the DueArray will copy the cell value into the DueArray (1,0),DueArray(1,1),DueArray(1,2). But if the condition = false, I want it to exit the inner j loop, go to next i loop iteration.

But the problem now is, whenever "If (Sheet2.Cells(i, 18) <= Date)" is TRUE.. it overwrites the data in the DueArray (1,0),DueArray(1,1),DueArray(1,2) instead of going to DueArray (2,0),DueArray(2,1),DueArray(2,2)and so on..

Could anyone help me with this? i've been spending days to figure out this problem.. Thanks in advance

Nway, i made some changes to the code..

Please Login or Register  to view this content.

I think you don't need the inner for loop.

Please Login or Register  to view this content.

thanks so much !
it works..its not that complicated than how i think it is..

cool.. please make this thread as solved