Problem with For To..

[calvinle]

Hi,

I have this code as example, but when I try to run it, it says:
"Next without For".

Am I missing anything, or doing anything not good?

Please Login or Register  to view this content.

Any help?

Thanks.

[alansidman]

I believe that your Next j statement needs to go after your End If statement or before your If statement. Can't really tell because I don't know what your intentions for work flow are.

[LJMetzger]

Hi calvinle,

You had the 'If Loop' wrapped around the 'Next j'.

Your code should look something like this:

Please Login or Register  to view this content.

Lewis

[sktneer]

It seems that your IF statement starts within For loop but Elseif and End If are out side the For loop (i.e. after Next j).

[Richard Buttrey]

Hi,

Yes your use of the If..End If is wrong. You can't start an IF block i side a loop and End it outside the loop. In general you must have

Please Login or Register  to view this content.

[calvinle]

Thanks everyone for your response.. The reason I add the "j" is to not have to repeat the same macro again, so I called it "j", for the macro to redo this whole process a second time:

Instead of having to do this:

Please Login or Register  to view this content.

I wanted to repeat this process 2 times without having to copy and paste this code 2 times, so I add a "j", and have to next j to go back to redo this code once again.

[calvinle]

It seems that your IF statement starts within For loop but Elseif and End If are out side the For loop (i.e. after Next j).

Absolutely right. I did not know that we cannot Next loop before the end if...

I solved it

Thanks everyone!