VBA to delete rows if column 1 and column 2 are numeric value >0

[Eylyn]

Policy	Sum Assured	Age
A	5000​	50​
B	x	40​
C	30000​	c
D	2000​	-12​
E	40000​	18​
F	70000​	25​
G	8000​	56​
H	h	48​

Hi,
I need help getting a macro to delete the entire row if column A is number>0 and column B is number>0, but it should not delete the row if column A or B contains alphabets or negative amount.

I have done some searching, but I was not able to find an example that can do this.
Column A = >0, Column B = >0 - Delete the row
Column A = x, Column B = >0 - Do not delete the row
Column A = >0, Column B = negative value - Do not delete the row

Any help will be greatly appreciated.

Regards

 

[Fluff]

Duplicate to: How to show all data with issues?

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.