Project getting stuck on a Do While statement

**archangel1177** · 07-15-2013, 04:52 PM

I am presently working on a project and I have some code that I am trying to get working but I really dont know all that much about VBA. What I am doing is in the workbook I have information and on each row in the 'L' column there is a numerical value. When that value says '4' I am looking to have the script copy/paste the information on to sheet 2 in the next row available and then delete the row on sheet 1 and move the information up so there are no gaps. Here is a link to my dropbox where the file is stored:https://www.dropbox.com/s/673estnvrh...ker%283%29.xls And here is the code I am working with. Thank you for all your suggestions and help in advance.

Please Login or Register  to view this content.

**Norie** · 07-15-2013, 05:08 PM

Loop backwards, starting from the last row with data.

**archangel1177** · 07-15-2013, 05:18 PM

Okay. Will that keep it from getting stuck? What I mean by getting stuck is that when I test the code, it stops in the 'Do While' line and hangs up on 'sheet1'.

**Norie** · 07-15-2013, 06:18 PM

When deleting you should always loop backwards/upwards.

I can't tell if it will help in your case as I couldn't open the file because the file extension doesn't match the file format.