Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$B$4" Then Range(Cells(7 + Target.Value, 1), Cells(37, 1)).EntireRow.Hidden = True End If End Sub
patel45, 16/01/2017 16.28: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$B$4" Then Range(Cells(7 + Target.Value, 1), Cells(37, 1)).EntireRow.Hidden = True End If End Sub macro da mettere nel modulo del foglio1. e per mostrare tutte le righe ci pensi tu ?
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$B$4" Then If Target.Value = "" Then Rows("7:50").Hidden = False Exit Sub End If Rows("7:50").Hidden = False Range(Cells(7 + Target.Value, 1), Cells(37, 1)).EntireRow.Hidden = True End If End Sub
Range(Cells(7 + Target.Value, 1), Cells(36, 1)).EntireRow.Hidden = True
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$B$4" Then If Target.Value = "" Or Target.Value = 30 Then Rows("7:80").Hidden = False Exit Sub End If Rows("7:80").Hidden = False Range(Cells(7 + Target.Value, 1), Cells(36, 1)).EntireRow.Hidden = True Range(Cells(42 + Target.Value, 1), Cells(70, 1)).EntireRow.Hidden = True End If End Sub