macro to unhide

[jzkemler1]

Hi!!
I have a spreadsheet that has rows 10-500 hidden. I am trying to create a macro that when run will unhide 10 rows at a time. So when it is run the first time rows 10-20 will be visable, then when run a second time rows 21-30 will be visable and so on. Can anyone help with how this code would look?

Thank you thank you so much from a newbie!!

Zoe

 

[JoeMo]

10-20 is eleven rows. 21-30 is ten. do you want ten at a time or 11 at a time?

 

[murrayty]

Check out the data tab and the option called group. It groups rows or columns(however many you want) together and they can be toggled to hide/unhide by pressing a button.

You can even group inside of groups to expand and shrink what you are viewing quickly. A very powerful tool if used properly.

 

[mikerickson]

Sub mySub()
    With ActiveSheet.Cells.SpecialCells(xlCellTypeVisible).Areas(1)
        .Rows(.Rows.Count).Offset(1, 0).Resize(10, 1).EntireRow.Hidden = False
    End With
End Sub

 

[jzkemler1]

Thank you murrayty, I will definately look into the grouping function, I have never used it before and it sounds like something I can use in the future.

@mikerickson that was exactly what I needed. I am so impressed and thankful for the skill that is on this board. You have helped me out so much. Thank you

Zoe