Is it possible to create an array that holds the names of all the visible worksheets in a workbook,
then use this array as a Data Validation List for a range of cells?
I know how to code a List box, to list all of the sheets,
but I’d rather have the user pick and choose from a drop down list in each cell.
After the user makes the selection, three other cells will be populated with data
from named ranges on each sheet.
I’ve include a workbook for illustration.
Thanks.
Bookmarks