ExcelBanter - Drop down list

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Drop down list (https://www.excelbanter.com/excel-worksheet-functions/257549-drop-down-list.html)

Rusty

Drop down list

When I "name" a range and put that name into the selection while creating the
drop down list. Then go to the cell and click on the arrow all i see is the
name of the range and it doesn't show the list to allow selection?
--
rustyrunrite

Gord Dibben

Drop down list

You must enter as =myrange

Note the "=" sign

Gord Dibben MS Excel MVP

On Sat, 27 Feb 2010 09:29:01 -0800, Rusty
wrote:

When I "name" a range and put that name into the selection while creating the
drop down list. Then go to the cell and click on the arrow all i see is the
name of the range and it doesn't show the list to allow selection?

All times are GMT +1. The time now is 12:20 AM.