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