Loop thru folder of files, delete rows with with 1 in column F; still some rows left

The loop VBA code is below that I am using. I have xlsx files with hundreds of rows. Column F is Boolean with 1 or 0. I need to delete all rows where there is a 1. The code runs great but at the end, each file still has some rows at the end that still have a 1. I've been reading about how you have to start at the bottom and delete up. Is this my problem. A push in the right direction would be great. I don't quite understand how to do this backwards. Much thanks.

Please Login or Register  to view this content.

walruseggman, Thanks for the prompt reply.

The code is hanging on your first line (rng...). Run-time error '91'. Object variable or With block variable not set. Can you elaborate on this error? Thanks.

Please Login or Register  to view this content.