top of page

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

It will work on whatever worksheet is currently selected in a workbook.

bottom of page