Deleting rows that meet two conditions

Please Login or Register  to view this content.

Actually, I just tried having both in one line and no errors.
So your error might have something to do with the criterias you are using.
For example, if you first select all blanks then try to select all formulas, you will get an error because there are no formula cells left

Hi, Nope it does not work Got the error message

"Cannot use that command on overlapping sections"

Please Login or Register  to view this content.

Btw as you probably notice I am quite new to VBA

Thanks

On which line of code are you getting the error?

The yellow one

Please Login or Register  to view this content.

It must be because the range that you are left with are 2 ranges that overlap in a specific way.
Break it down into 2 deletes:

Please Login or Register  to view this content.

Hmm but now rows where for example only column H is blank and not column F will be deleted? no?

Yes but I think if your original code worked, it would have done the same thing.

If you have to put 2 criterias at the same time, you would have to use some kind of AutoFilter

Ok but thanks a lot for your help!
Maybe someone knows how to do that?

Cheers