Multiple Ranges issue

[elecgenius]

Hello,

I am having issues with the following code:

Please Login or Register  to view this content.

fRange is not working, the first 2 loops work but not this one. I cannot get it to work.

Could someone help me with this please?

[Richard Buttrey]

Try changing the Ands to Ors.

Incidentally looping through ranges of cells can be extremely slow and inefficient. For this sort of thing it's much more efficient and elegant to use an Autofilter to show the cells you want to delete, and then use the

fRange.SpecialCells(xlCellTypeVisible).EntireRow.Delete

This only requires VBA to address the sheet once rather than jumping back and forth