VBA Code - Autofilter and delete

[Shark Man]

Hello Experts

I have a code that dosent work that need to filter "FALSE" and delete all FALSE lines
( in the fle i have more than 40,000 lines)

Please Login or Register  to view this content.

Thanks
Shark

[DonkeyOte]

If you iterate and delete you should always work bottom up rather than top down
(ie For r = LR To 2 Step -1 [and removed the r=r-1])

Without knowing your setup (headers etc) you could as you say avoid the iteration and apply an Auto Filter

Please Login or Register  to view this content.