ListBox with Horizontal Values

[Scott Halper]

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

 

[Max]

Consider using a DV droplist instead.
It works even with a horiz named range.