VBA code to auto-hide row based upon entries in a range of cells in this row

[virtuosok]

Hi,
I would really appreciate help with VBA code to hide a given row based upon entries in columns F-N in the same row.
Total number of rows to apply this rule to is 20 (i.e. rows 10-29)
More specifically, cells in columns F-N all have a SUMIF type of formula which returns either zero or a different number (0.5...200).
I want to hide row 10, if all formulas in 10F:10N return 0
Likewise, hide row 11, if all formulas in 11F:11N return 0...
and so on.
Is it possible?

 

[Marc L]

​

So add the filtering in the Worksheet_Change event …​