VBA Delete Rows if 2 conditions are 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 Notes, If it is empty delete that Row.

In the example below rows 4 & 5 would be deleted as they have an AI value = 0 and no Notes.


[TABLE="width: 500"]
<tbody>[TR]
[TD]1
[/TD]
[TD]Date
[/TD]
[TD]Team
[/TD]
[TD]AI
[/TD]
[TD]Match
[/TD]
[TD]Notes
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]9/1/2019
[/TD]
[TD]Team 04
[/TD]
[TD]0
[/TD]
[TD]yes
[/TD]
[TD]checked
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]9/5/2019
[/TD]
[TD]Team 01
[/TD]
[TD]4
[/TD]
[TD]yes
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]9/7/2019
[/TD]
[TD]Team 05
[/TD]
[TD]0
[/TD]
[TD]no
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]9/12/2019
[/TD]
[TD]Team 03
[/TD]
[TD]0
[/TD]
[TD]yes
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]9/15/2019
[/TD]
[TD]Team 07
[/TD]
[TD]2
[/TD]
[TD]yes
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]9/22/2019
[/TD]
[TD]Team 11
[/TD]
[TD]0
[/TD]
[TD]yes
[/TD]
[TD]checked
[/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]9/30/2019
[/TD]
[TD]Team 09
[/TD]
[TD]1
[/TD]
[TD]no
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Thank you for any and all help!

 

[Fluff]

You can use autofilter for that, just filter the AI column for 0 and the notes column for blanks & then delete the rows.
If you want the code, then use the recorder whilst you do it manually.

 

[LNG2013]

You can use autofilter for that, just filter the AI column for 0 and the notes column for blanks & then delete the rows.
If you want the code, then use the recorder whilst you do it manually.

Thank you for your reply, unfortunately it is for a report I am building that others will be running and 2 additional conditions were just added too.
I will repost with additional conditions.

Thank you again.