View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default duplicate listbox selection to range of cells?

ActiveCell.Resize(1, 7).Value = .List(mypick)
or
ActiveSheet.Range("a1:g1").Value = .List(mypick)

lozc wrote:

Thanks Dave,

That was certainly useful, but I am looking for the value to be
duplicated to a set range of consecutive horizontal cells (eg A1:G1),
rather than consecutively from the current active cell, any ideas?

Thanks Again

--
lozc
------------------------------------------------------------------------
lozc's Profile: http://www.excelforum.com/member.php...o&userid=31340
View this thread: http://www.excelforum.com/showthread...hreadid=510269


--

Dave Peterson