Simple Loop command

Hi All,

Really simple question here. I'm trying to delete a row if the value in the Column 62 is 0.

Here's what I have so far:

Please Login or Register  to view this content.

It runs ok and deletes the row but doesn't seem to recognise when the value in column 62 (BJ) is equal to 1.

can anyone help?

Thanks

When deleting rows, always start from the bottom.

Try this:

Please Login or Register  to view this content.

Regards

Originally Posted by abousetta

Hi,

This seems to work for me, unless I don't understand the problem:

abousetta

Yep, tried it again and it seemed to work.

I'll try to new code to delete from the bottom.

Thanks for the help guys.

Starting from the top can "seem" to work unless you encounter several rows together that meet the criterion. Then you can leapfrog rows.

Regards