VBA to Hide & Show Rows

Hi all,


I'm a complete noob when it comes to VBA scripts, I've never used it before and I'm not a programmer at all. I found a VBA script online and I don't know enough to modify it to suit my needs.


The script has 2 functions - HideRows and ShowRows. When you run them, you are asked to specify a range. For example, I can provide the following range:

'Sheet 1'!H7:H24


It will then look at the cells at H7~H24 in Sheet 1 and hide or unhide the row(s), depending on whether the cell value is a 0 or not.


What I'm trying to do is to provide multiple ranges from multiple sheets. E.g:

'Sheet 1'!H7:H24

'Sheet 2'!D5:D19


The problem is that the VBA script seems to only allow one range at a time and I need to modify this to allow multiple ranges.


For reference, I have attached a test Excel spreadsheet for you to play around with.

HTML Code: 

HTML Code: