Move rows only does the first one

[treva26]

I have this sub that is supposed to move any rows with 'ERROR' in column 33 to a new row in the ERRORS sheet

For some reason it only does the first one and i cant figure out why.
It also doesnt delete the row it has cut from in the IMPORT sheet.

Can anyone see where the problem is?
Or perhaps a better way of doing it?

Please Login or Register  to view this content.

[mikerickson]

You need to work from bottom to top, so that moving a row doesn't disturb the rows you haven't yet inspected.

Please Login or Register  to view this content.

[treva26]

good point

but its still only doing one...

[treva26]

i got it working now...somehow

Please Login or Register  to view this content.