I have a drop down box; the input range is from a row not a column. The
selection in the drop down box appears when the input range is from a column.
I cant get it to work when a row is selected. I would like to have the
selection from a row.

The row starts from cell J178 onwards. Is there a way to get the row to
appear in the drop down box?

Many thanks