Akorát upravit to co je ve skutečnosti jako 0 ve sloupci C
Sub Skryj_Zobraz()
Dim iRow As Integer
Application.ScreenUpdating = False
If Columns("F:F").EntireColumn.Hidden Then
Columns("F:F").EntireColumn.Hidden = False
Rows("1:100").EntireRow.Hidden = False
Else
Columns("F:F").EntireColumn.Hidden = True
For iRow = 1 To 100
If Cells(iRow, "C").Value = 0 Then
Rows(iRow & ":" & iRow).EntireRow.Hidden = True
End If
Next iRow
End If
Application.ScreenUpdating = True
End Subcitovat
Sub Skryj_Zobraz()
Dim iRow As Integer
Application.ScreenUpdating = False
If Columns("F:F").EntireColumn.Hidden Then
Columns("F:F").EntireColumn.Hidden = False
Rows("1:100").EntireRow.Hidden = False
Else
Columns("F:F").EntireColumn.Hidden = True
For iRow = 1 To 100
If Cells(iRow, "C").Value = 0 Then
Rows(iRow & ":" & iRow).EntireRow.Hidden = True
End If
Next iRow
End If
Application.ScreenUpdating = True
End Subcitovat