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

Consider using a DV droplist instead.
It works even with a horiz named range.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
On Mar 27, 6:16 am, "Scott Halper"
wrote:
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