Hmm, I may be forum-ly challanged, because I don't see a link to attach the workbook.
Pretty much what I am trying to do is, when this button creates a new worksheet, I would like to add a dropdown menu in one of the cells that uses a named array as its data. The named array is a dynamic list based off of data in another worksheet.
So far I've found the code:
This creates a drop down menu in cell 1,1, but I cannot seem to get that drop down to reference the named array "bleh" as its data.
And yes, these worksheets are in the same workbook
Any input?
Bookmarks