Advertisement
Guest User

Untitled

a guest
Jan 18th, 2017
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. shtOTP.Outline.ShowLevels RowLevels:=4
  2. shtOTP.Outline.ShowLevels RowLevels:=3
  3. shtOTP.Outline.ShowLevels RowLevels:=2
  4. ActiveWindow.ScrollRow = shtOTP.Range("A3").row 'Go to top of sheet
  5.  
  6. For i = 3 To getLastRow
  7. Dim nextRow As Integer
  8. nextRow = shtOTP.Rows(i+1).row
  9. If nextRow = ParentRow And i.EntireRow.Hidden = False Then
  10. 'Collapse the group below the product
  11. End If
  12. Next
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement