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:
Bookmarks