Needing to have entire row deleted using VBA IF either of these 2 Rules are TRUE:
Rule #1 IF cell in Col A (is populated with anything) but cell in Col C (is blank)
AND/OR
Rule #2 IF cell in Col D has the #VALUE error present

Conditional Range would apply to: rows 7:40

Hopefully, I'm wording that correctly...
If a row is found where Col A is populated but Col C is blank (delete that row)
.. also
If a row is found where Col D has the #VALUE error present, delete that row too


Thank you in advance!