specialcells issues

I seem to be having trouble with this line of code. Using the specialcells method deletes all the rows in the spreadsheet. This works most of the time but every now and again for large spreadsheets it doesn't work. I was wondering if any of you might have any suggestions?

Please Login or Register  to view this content.

If SpecialCells finds a range with more than 8192 areas (non-contiguous subranges), it kindly returns the entire range, which is bad behavior.

So you need to write a loop that deletes in 16,000-row groups, bottom to top.