VBA Help Delete Row if 3 conditions met?

[LNG2013]

Hello I need help with a bit of VBA code.

I need the code to look at Column AI.
Column AI can have a value of 0-7.
If a Row in Column AI has a value of "0" check column Probed, If it is empty check Notes, if also empty delete that Row.

In the example below row 8 would be deleted as AI = 0, Probed is empty, and so is Notes.


[TABLE="width: 500"]
<tbody>[TR]
[TD]1
[/TD]
[TD]Date
[/TD]
[TD]Probed
[/TD]
[TD]Area
[/TD]
[TD]Team
[/TD]
[TD]AI
[/TD]
[TD]Match
[/TD]
[TD]Notes
[/TD]
[TD]GI
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]9/1/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD]Team 1[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]9/5/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD]Team 11[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]9/7/2019[/TD]
[TD]Not[/TD]
[TD][/TD]
[TD]Team 3[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]9/12/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD]Team 4[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]9/15/2019[/TD]
[TD]Not[/TD]
[TD][/TD]
[TD]Team 7[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]9/22/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD]Team 9[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]9/30/2019
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Team 4
[/TD]
[TD]0
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]10/1/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD]Team 2[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]10/02/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD]Team 6[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]other[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



Thank you for any and all help!

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1111292-vba-delete-rows-if-2-conditions-met.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).