delete rows from AutoFilter or Advanced Filter range

  • Thread starter Thread starter Gareth
  • Start date Start date
G

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
 
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.
 
Back
Top