macro on excel***Urgent***

[evswifey]

could someone help me to create a macro?

Delete rows where multiple column meets multiple criteria.

detail:
delete rows where
Column H is less than 10000
AND
Column C is empty(blank)

Those 2 criteria have to occur at the same time..

Thank you!

Best Regards

 

[JoeMo]

Try:

Sub DeleteRows()
Dim lRw As Long
lRw = ActiveSheet.Range("H" & Rows.Count).End(xlUp).Row
For i = lRw To 1 Step -1
    If Cells(i, "H").Value < 10000 And IsEmpty(Cells(i, "C")) Then Rows(i).Delete
Next i
End Sub