Delete entire rows by conditions

[Panoos64]

Hi to all of you!
Kindly require to provide me support for a VBA code so that to run through columns "O", "P", 'Q" and where the rows are blank or "0" should delete entire rows. Therefore that, the rows "1" - "7" are headings and the code should run from row "8" till rows down. Thank you all in advance. Base into all of you, i overcome my tasks in a short time and my figures are accurate.

 

[Panoos64]

Re: Delete entire rows by contitions

Thank u Peter, the code works perfect. regarding your 2nd comment, therefore the below:
- spreadsheet doesn't contains any text values in mentioned columns
- in case that the rows contains any numbers, positive or negative the code should not delete them.
I would like to thank you once again for your so nice work and your continued support.
Hv a great day!

 

[Panoos64]

Re: Delete entire rows by contitions

Thank u Dante! it works nicely and based to my data. Thanks for your time spent for my project. Hv a lovely day!

 

[Panoos64]

Re: Delete entire rows by contitions

Many thanks Trebor, it works correct too, thank u once again that you spent time for my project. Hv a nice day!

 

[DanteAmor]

Re: Delete entire rows by contitions

Thank u Dante! it works nicely and based to my data. Thanks for your time spent for my project. Hv a lovely day!

I'm glad to helo you. Thanks for the feedback.

 

[Peter_SSs]

Re: Delete entire rows by contitions

Thank u Peter,

You're welcome. Thanks for the follow-up.