excel macro to hide multiple ranges of rows
Tonight, I used the below macro (posted here) to automatically hide multiple ranges of rows on a Excel worksheet.
This vba code is easy to edit, and tonight it successfully hid more than 70 ranges in a few seconds.
Sub Hide()
ActiveSheet.Rows("3:4").Hidden = True
ActiveSheet.Rows("7:8").Hidden = True
End Sub
![](https://static.wixstatic.com/media/af7fa4_47aa23d922504861883fd8e1f03b1483~mv2.png/v1/fill/w_980,h_694,al_c,q_90,usm_0.66_1.00_0.01,enc_auto/af7fa4_47aa23d922504861883fd8e1f03b1483~mv2.png)
It will work on whatever worksheet is currently selected in a workbook.
![](https://static.wixstatic.com/media/af7fa4_5576518d53cc44d8a704ac9f6a297aa9~mv2.png/v1/fill/w_538,h_450,al_c,q_85,enc_auto/af7fa4_5576518d53cc44d8a704ac9f6a297aa9~mv2.png)
Kommentare