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.
|