hide rows if cell value is zero or blank in one or multiple columns.

I have a code which hides entire row if a cell in particular column contains zero value, I want it to be applicable for selected range (not entire column) and also applies to blank cells (including cells containing zero)

Please Login or Register  to view this content.

Is this what you want?

Please Login or Register  to view this content.

Dear Oz,

two issues-
1) Its hiding the rows of selected cells which i don,t want if any cell has value except 0 of blank
2) I want to put range in code itself instead of selecting the cells to hide rows in the range of selected cells which contains 0 or blank.

its working perfectly.
thanks a lot.

Happy to help.
If you liked my solution click on "Add Reputation" at the bottom left of the post.

thank you for your sharing