Deleting rows that meet two conditions

[Nils88]

Dear all!

I am trying to delete all rows in my sheet where Column H and F are blank.

Please Login or Register  to view this content.

I know how to do it with one criteria but when I add the second one it stops working. Any suggestions?

Regards

[jason_lee_91]

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

[Nils88]

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

[jason_lee_91]

On which line of code are you getting the error?

[Nils88]

The yellow one

Please Login or Register  to view this content.

[jason_lee_91]

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.

[Nils88]

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

[jason_lee_91]

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

[Nils88]

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

Cheers