Re: Listbox: ListFillRange

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Mangesh....Thanks for the information. It is curious, however, that the
documentation for ListBox and ComboBox do not detail this requirement for
the range. Thanks again....Rob

"mangesh_yadav" <mangesh_yadav.1qpdua_1118898300.7924@xxxxxxxxxxxxxxxxxxxxx>
wrote in message
news:mangesh_yadav.1qpdua_1118898300.7924@xxxxxxxxxxxxxxxxxxxxxxxx
>
> The ListFillRange takes the source only through a column and not from a
> row. You could do the following thing. Select as many cells (11 in your
> case) in a column as are in your original row. And then enter the
> formula
> =TRANSPOSE("E15:E25")
> Note that the cells in the column are selected. And the formula goes in
> the first cell. Press Control Shift Enter as this is an array formula.
> Now use this column as the source.
>
> Mangesh
>
>
> --
> mangesh_yadav
> ------------------------------------------------------------------------
> mangesh_yadav's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=10470
> View this thread: http://www.excelforum.com/showthread.php?threadid=379568
>


.

Relevant Pages

  • Re: More than one Target.Addresses
    ... Sorry, I meant ListFillRange of the Combobox, not FillBox. ... after I use the drop down comboboxes to enter the text in the target cells. ... The "target" is the range that was changed on the worksheet. ...
    (microsoft.public.excel.programming)
  • Re: listbox or combo box and how?
    ... The button puts the selected items into a cell, er, a bunch of cells. ... "Dave Peterson" wrote: ... That's the name of the listbox. ... Once I get this set up will my staff be able to select multiple selections ...
    (microsoft.public.excel.misc)
  • Re: listbox or combo box and how?
    ... cells are merged, but at the top of the page I have merged cells, is this the ... "Dave Peterson" wrote: ... ok I see what I did wrong there and fixed that now I get a merged cell error ... That's the name of the listbox. ...
    (microsoft.public.excel.misc)
  • Re: Finding/removing an "obascure" manual page break
    ... rows of columns 5 & 6), by merging the appropriate cells, then ... >> so that the original row is split across this page break. ... >> is plenty of white space for the entire original row to be all on one ... >> Fred Holmes ...
    (microsoft.public.word.tables)
  • Re: Array Question
    ... Assuming your original data is in Row 1, enter this *array* formula anywhere ... When an additional cell is added to the original row I want the new data to ... I want the new row to look at additional cells so that it will always have ... nonzero cells from the original row of data beginning with the cell ...
    (microsoft.public.excel.misc)