Data Validation Combo Box - Horizontal Named List

I need to create a data validation combo box with an autofill feature. I have the following slightly modified code from the contexture website that works but only when the named lists are vertical. I need to use horizontal named lists because I have more lists than available columns in excel (350). Also I have a macro that creates the horizontal named lists automatically. I have searched multiple forums and it does not look like this issue is solved anywhere, and people just suggest that the lists are recreated vertically. Is it possible to have a data validation combo box run off of a horizontal list?

Please Login or Register  to view this content.

I have attached the following sample file. As you can see the code runs on the vertical list (Market1) but not on the horizontal list (Market).

Thank you so much for your help!

Moderator's Note: Welcome to the forum. You have to put code tags around codes. Sleelct the code then hit the "#" sign. I'll do it gor you now. Thanks.

Hi AlliG

Welcome to the Forum! Please wrap your code in Code Tags then try this

Please Login or Register  to view this content.