Hi,
Simply convert the range to a Table (Ctrl+L). When you convert a range to a
Table, it auto expands
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Marge" wrote in message
...
I have a range of cells (named staff) on a worksheet in the workbook where
the drop down list will be used. Additional cells were added to the range
of
cells, but I can't get Excel to include them on the named list. Can I not
expand the range of cells or do I need to name the expanded list with a
new
range name?