IF cell in Col A is populated BUT cell in Col C is blank DELETE ROW
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!
|