Unhide specific number of rows

[Alleen86]

Hello!

I hope someone could give me an example of macro for hiding specific number of rows.

All rows from 6 to 1048576 in my sheet are hidden. I have a value in one cell (let's say, 50). Now, I would like to unhide 50 rows (based on value in that cell), start from row 6.

How to do that with macro?

[Cutter]

Something like this:

Please Login or Register  to view this content.

This assumes your value (eg 50) is held in cell A1 so change to suit

[Alleen86]

Thank you very much!

[shg]

Or, similarly,

Please Login or Register  to view this content.