Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
custom views / macros
I created a custom view from a master document that included every third row
hidden (I manually hid every third row for 1000 rows -whew!). I added a macro that showed a particular heading row for that view, and assigned a shortcut. I saved the worksheet as a template. The worksheet was then re-saved with a new name, cells filled in. The custom view worked a few times, then stopped hiding every third row in the view. 1. I don't know why the view stopped hiding the rows and 2. can you help me write a macro that will automatically hide every third row?? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom views / macros | New Users to Excel | |||
Custom Views!!! | Setting up and Configuration of Excel | |||
Custom Views | Excel Discussion (Misc queries) | |||
Custom Views | Excel Discussion (Misc queries) | |||
Custom Views | Setting up and Configuration of Excel |