Hide Rows in Range Based on Value in Column

[blairski10]

I have a worksheet that pulls data from another sheet to show spend data in various categories (rows). The data in the range changes based on criteria that I put in a specific cell. I want to be able to hide/unhide rows dynamically every time I change the data in the specific cell if the value in a specific column is "hide" (based on an IF statement "IF(ColumnD+ColumnE=0,"hide","show")."

Is there VBA code that will hide these rows if it matches the criteria AND then 1) resets to the full them all when I select a new criteria and then hides again for zero values?

 

[Batbloke]

You could just set the row.height to zero when value = 0, and then expand it when needed.