Transfer ListBox items to a range
 

What would be the best approach to transfer the values from a listbox to a
range.

I will be using a standard "last row" routine, and then pasting the values
below the last row.

Thanks in advance.

Transfer ListBox items to a range
 

Here's one way:
Range("A10").Range("A1:A" & ListBox1.ListCount).Value = ListBox1.List

NickHK

"AD108" bl...
What would be the best approach to transfer the values from a listbox to a
range.

I will be using a standard "last row" routine, and then pasting the values
below the last row.

Thanks in advance.

Transfer ListBox items to a range
 

Thanks for that,


"NickHK" wrote in message
...
Here's one way:
Range("A10").Range("A1:A" & ListBox1.ListCount).Value = ListBox1.List

NickHK

"AD108"
bl...
What would be the best approach to transfer the values from a listbox to
a
range.

I will be using a standard "last row" routine, and then pasting the
values
below the last row.

Thanks in advance.