Do without Loop Error.... please help...

I have been trying to resolve this issue but no success. Everytime I tried to run the code it gives Bach "Do without Loop" error. I checked the codes and so far no luck in finding the error. I have Do and End If on every statements so I am not sure anymore what is the problem. Please help. Thank you.

Please Login or Register  to view this content.

Hi and welcome to the forum. Unfortunately your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

In addition you need to tell us what your 'issue' is with the code. You can't expect us to guess.

Edit Your post select your code and hit # button for Code Tag.

In your code there is lot of if condition do you know which End if belonging to which if?

there is two "Do While" but ther is only one "Loop" and One Loop word Missing

tabing code is best for understand

here is your code

Please Login or Register  to view this content.