What type of DropDown box?

If a Data Validation list just select the range across the row as the list
range.

i.e. J178:BA178


Gord Dibben MS Excel MVP


On Thu, 19 Jun 2008 13:24:03 -0700, zephyr
wrote:

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 can’t 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