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.




Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com