Need loop to continue instead of end

[lordterrin]

I have the following code:

Please Login or Register  to view this content.

This code launches an external program and does stuff based on the contents of each cell between s3 and s5000, assuming it doesn't hit a blank cell. If it hits a blank cell, it stops the macro.

It works GREAT, except that when I wrote this, this piece was the last section, so it was fine for me to Exit Sub once it found a blank cell. However, I've changed the macro now to do other stuff afterwards, and I need it to continue on to the next piece of code once it hits a blank cell instead of doing the Exit Sub.

I don't know the syntax for this though.

[slx]

Please Login or Register  to view this content.

[David A Coop]

Hi Lord Terrin,

You could try changing the Exit Sub to GoTo 100 and after the End If and before the additional code, type 100:

Regards,
David

[AB33]

Untested.

Please Login or Register  to view this content.

[lordterrin]

Please Login or Register  to view this content.

This worked perfectly - thank you. It makes sense as I just want to stop the "For" loop from running.