ExcelBanter - how do i add a list to the existing drop down list?

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do i add a list to the existing drop down list? (https://www.excelbanter.com/excel-discussion-misc-queries/264621-how-do-i-add-list-existing-drop-down-list.html)

Lorelie

how do i add a list to the existing drop down list?

Please inform me by replying to my email address. thanks.

Gord Dibben

how do i add a list to the existing drop down list?

Asked here.........answered here.

Simply add items to the current list then re-define the range in
InsertNameDefine.

Gord Dibben MS Excel MVP

On Thu, 27 May 2010 14:23:37 -0700, Lorelie
wrote:

Please inform me by replying to my email address. thanks.

All times are GMT +1. The time now is 09:46 AM.