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.

Gareth wrote:
>
> 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