Repeating a loop multiple times

[Jonathan78]

Hello all,

The following code populates a range with values from a listbox.
The listbox length is variable.
lets say that the listbox contains for example 25 items.
The code will fill the range with 25 items.
How can I keep the loop until it fills the range with for eample 200 items.

Please Login or Register  to view this content.

[Neil_]

.ListCount informs the loop. If there are 200 items in the list, it will continue until the end of the list. If you change it to

Please Login or Register  to view this content.

and there aren't 200 items in the list, the code will throw an error

[Neil_]

i read your post again.

Please Login or Register  to view this content.

[Jonathan78]

Thanks Neil, that worked just great!