Hi.
I am attaching a sample spreadsheet with code that I used from Contextures.com (https://www.contextures.com/xldataval11.html).
I added my named ranges, data validation, and combo boxes.
On my named ranges, I purposely only made one of them a dynamic range using INDEX, ROWS, and COUNTBLANK. This is the only range that does not show up in the combo box drop-down.
I need to know what I need to change in the code for the sheet or in the named range to make it show up. I do not want all of the blank rows at the end of the list to appear in the combo box.
Any help is appreciated.
Bookmarks