Dependent Drop-down with Dynamic Named Ranges

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.