AW: makro leere ausblenden
18.03.2024 14:48:18
UweD
Hallo
so?
Sub Aus()
Dim Z1 As Integer, S1 As Integer, LR As Long, LC As Integer, i As Long, RNG As Range
Z1 = 11 'erste Zeile mit Daten
S1 = 4 'Daten ab Spalte D
LR = Cells.SpecialCells(xlCellTypeLastCell).Row 'Letzte Zeile des gesamten Blattes
LC = Cells.SpecialCells(xlCellTypeLastCell).Column 'Letzte Spalte des gesamten Blattes
Set RNG = Cells(Z1, S1).Resize(LR - Z1 + 1, LC - S1 + 1)
'reset
Call Ein
For i = Z1 To LR
If WorksheetFunction.Sum(Intersect(Rows(i), RNG)) = 0 Then
Rows(i).Hidden = True
End If
Next
End Sub
Sub Ein()
Cells.EntireRow.Hidden = False
End Sub
LG UweD