Hide two sets of rows separately

Asked Aug 03 '14 at 20:09

Active Mar 26 '15 at 21:27

Viewed 85 times

I have Excel VBA with 2 buttons. When one is clicked certain rows are hidden and when the other one is clicked another selection of rows are hidden.

When I try to hide both sections of rows it gives me a run-time error 1004

Private Sub CommandButton1_Click()
    With Rows("7:14")
        .Select
        .EntireRow.Hidden = Not .EntireRow.Hidden
    End With
End Sub

Private Sub CommandButton2_Click()
    With Rows("16:24")
       .Select
       .EntireRow.Hidden = Not .EntireRow.Hidden
    End With
End Sub

edited Jul 09 '18 at 19:34

Community

asked Aug 03 '14 at 20:09

Llewelyn Nutsman Grobler

2

No-repro, works fine. Still, [do not use Select](http://stackoverflow.com/q/10714251/11683). – GSerg Aug 03 '14 at 20:19
Name the fist cell of the row and use `Range("name").EntireRow.Hidden = ...` – John Alexiou Aug 03 '14 at 20:27

Hide two sets of rows separately

0 Answers0