K
kartk
Hi,
I have an requirement in excel to Expand & collapse rows for a certai
range.
Below is the code written for the same,
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, [H5]) Is Nothing Then
[6:10].Rows.Hidden = True
'End If
If Not Intersect(Target, [E:E]) Is Nothing Then
[6:10].Rows.Hidden = False
End If
End Sub
However if an user insert a new row i want to include the additional ro
dynamically to the existing range. Please hel
I have an requirement in excel to Expand & collapse rows for a certai
range.
Below is the code written for the same,
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, [H5]) Is Nothing Then
[6:10].Rows.Hidden = True
'End If
If Not Intersect(Target, [E:E]) Is Nothing Then
[6:10].Rows.Hidden = False
End If
End Sub
However if an user insert a new row i want to include the additional ro
dynamically to the existing range. Please hel