worksheet functions >> ListBox with Horizontal Values
I have a named Range that containts horizontal column headings on one
sheet and I want to have a list box (where users can just click the
column they desire) and then calculations adjust accordingly. When I
insert the ListBox into my other sheet and select ListFillRange
"MyNamedIndex" it only inserts the first column but none of the others
in the horizontal row.
worksheet functions >> ListBox with Horizontal Values
Consider using a DV droplist instead.
It works even with a horiz named range.
--
Max
Singapore http://savefile.com/projects/236895
xdemechanik
---
> I have a named Range that containts horizontal column headings on one
> sheet and I want to have a list box (where users can just click the
> column they desire) and then calculations adjust accordingly. When I
> insert the ListBox into my other sheet and select ListFillRange
> "MyNamedIndex" it only inserts the first column but none of the others
> in the horizontal row.
>
> Thanks for the help.
>
> Scott