Hello,

I'm trying to use a (form control) scrollbar on a worksheet to cycle through
a vertical (column) list of 12 month (January - December).
The length / address of the month's list (named range) must adapt to the
remaining # of months.

For example: if I pick March (= index 3 of the scrollbar's cell-link, the
month's list should have left 9 rows (April - December).
If I choose scroll to October, the list (named range) should only have 2
rows left (November - December), etc.

Any idea how to do it, possibly with Offset(....) ?

Thank you in advance.

Kind regards,

hgl