Hi Marc,
Try:
'=================>>
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rw As Range
Dim i As Long
Const StartCol As String = "B" '<<==== CHANGE
Const EndCol As String = "I" '<<==== CHANGE
If Not Intersect(Target, Columns(StartCol & _
":" & EndCol)) Is Nothing Then
For Each rw In Target.Rows
i = rw.Row
Rows(i).Hidden = Application.Sum(Range(Cells _
(i, StartCol), Cells(i, EndCol))) = 0
Next rw
End If
End Sub
'<<================
Cgange the StartCol and EndCol values to suit.
..
This is worksheet event code and should be pasted into the worksheets's
code module (not a standard module and not the workbook's ThisWorkbook
module):
*********************************
Right-click the worksheet's tab
Select 'View Code' from the menu and paste the code.
Alt-F11 to return to Excel.
*********************************