Hide certain rows from given list

[barqujo]

Hello everyone,

I have this problem, I'm sure you can help!

Let's say I have a given list of numbers in a worksheet


2
5
7
9
12
15
16
33
43

And in another worksheet I have a range of 50 rows hidden (from A1 to A50)

I need a macro that unhides only the rows corresponding to the numbers in the list, that is row 2, 5, 7, 9, 12, ...


Also the amount of numbers in the list is variable (between 1 and 50)


Thanks!!!

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[HaHoBe]

Hi, barqujo,

from what I understand you may have a go with this, the numbers are located in Sheet1 starting with A1 downwards with no blanks:

Please Login or Register  to view this content.

Ciao,
Holger

[barqujo]

Hello HaHoBe

It just what I needed thank you!!