Dim wks As Worksheet
For Each wks In Worksheets
Dim i As Long
For i = 10 To 348
If Application.CountA(wks.Cells(i, 2).Resize(, 7)) = 0 Then
wks.Rows(i).Hidden = True
End If
Next i
Next
End Sub
bin ziemlich verzweifelt, weiß aber, dass hier die Profis dafür sind.
Gruß Christiane