Thank you! I now understand the dynamic range posted on the site :) good to
know.
I don't understand how I would go about referencing the whortsheet names in
a workbook, without typing them into the dynamic list.
I want the list to be an auto updating list of the names of the worksheets.
How do I reference all the worksheet names?
Thanks again
"Gord Dibben" wrote:
Define a dynamic range and give it a name then use the name as your source in DV
=MyList
See Debra Dalgleish's site for creating and naming dynamic ranges.
http://www.contextures.on.ca/xlNames01.html#Dynamic
Gord Dibben MS Excel MVP
On Mon, 10 Dec 2007 10:59:03 -0800, fryguy
wrote:
I am stumped. I would like to create a list from all the worksheet names in
a workbook. I have created these lists before by typing the names into a
list and using data validation to create the list.
Can the list be automatically updated when a new sheet is added or one is
deleted without manually changing the list each time?