View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scott Halper Scott Halper is offline
external usenet poster
 
Posts: 32
Default 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.

Thanks for the help.

Scott