Macro to hide/unhide rows based on column value

[tlc53]

Hi there,

I've tried a couple of different codes but can't quite pull it together.

In Columns G15:G49 and H15:H49 I have formulas. If both cells in the columns equal zero (eg. G15 & H15), I would like to hide that row (row 15). If one is more than zero, it should be visible. If the data changes later, I would like them to unhide/hide accordingly.

Can someone help me please?

Thanks!

 

[tlc53]

Eureka! I changed that line and it works perfectly now. Thank you!

 

[Fluff]

You're welcome & thanks for the feedback