Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- shtOTP.Outline.ShowLevels RowLevels:=4
- shtOTP.Outline.ShowLevels RowLevels:=3
- shtOTP.Outline.ShowLevels RowLevels:=2
- ActiveWindow.ScrollRow = shtOTP.Range("A3").row 'Go to top of sheet
- For i = 3 To getLastRow
- Dim nextRow As Integer
- nextRow = shtOTP.Rows(i+1).row
- If nextRow = ParentRow And i.EntireRow.Hidden = False Then
- 'Collapse the group below the product
- End If
- Next
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement