dynamic drop down list

[MaartenRo]

Hi,
I have written a macor that creates a drop down list in cell F2. Because the range is dynamic (it varies between 1 to 10 cells), the list contains the values of the range F2:F10. As a result the list conmtains many empty spaces.
I would like the list to show only the values of the cells below F2, so if there are 5 values the list should contain only these 5 values. I guess i should change something in the line :

Please Login or Register  to view this content.

How can i adapt my macro for attaining this goal?

Please Login or Register  to view this content.

[Sintek]

Please Login or Register  to view this content.