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.




Comments


bottom of page