Worksheet Change - Unhiding variable amount of rows

[hk57]

I want to build a worksheet change function that will unhide a variable amount of rows.

If the value in a cell, say A1, is changed then it will hide that amount of rows in seven different areas along the sheet. So I type in 30 and rows 16:45, 91:120, 166:195, 241:270, 316:345, 391:420, and 466:495 would all become visible. Or if I type in 45 then rows 16:60, and etc would become visible; or type in 60 and rows 16:75, and etc would become visible.

I know I could build a worksheet change function that will vary from any input to unhide each row individually; I just don't want a code that would have 180 variables and have to individually name 1260 different cell ranges.

P.S. The row examples I gave are obviously from my current sheet, which is set to have 1-60 in seven different segments - technically I want it to be 1-120 or 1-180 instead of having to manually add in the extra rows when needed.

[p24leclerc]

I'm not really sure if I understand all of your problem but here is a start.
The macro will first hide all rows in this range :A16:A1000
Then, it will unhide the rows as you specified.

Please Login or Register  to view this content.

See attach file

[mehmetcik]

Please Login or Register  to view this content.