delete rows from AutoFilter or Advanced Filter range

[Gareth]

I can use either method to filter my sheet, it is possible that I am left
with 10,000 rows + that I need to delete. I believe that that specialcells
has a max of 8,192 that it will delete. How can I get around this?

Thanks.

Gareth

 

[Dave Peterson]

The problem with specialcells is that it can't exceed 8192 areas--not rows.

So even if you have 10000 rows and wanted to delete every other row, you're
still at 5000 areas.