View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK[_3_] NickHK[_3_] is offline
external usenet poster
 
Posts: 415
Default 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.