View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
curlydave curlydave is offline
external usenet poster
 
Posts: 206
Default custom views / macros

This will Hide every third row starting with row 3 change the "For
i=3" to whatever row you want it to start at

Sub HideThirdRow()
fnl = Cells(65536, 1).End(xlUp).Row
For i = 3 To fnl Step 3
Cells(i, i).EntireRow.Hidden = True
Next i

End Sub

This will un-Hide the rows

Sub UnHideRows()
fnl = Cells(65536, 1).End(xlUp).Row
For i = 1 To fnl Step 2
Cells.EntireRow.Hidden = False
Next i

End Sub