Hi,

I'm trying to debug some code where I'm trying to retrieve particular ranges in an excel sheet into an Access table, depending on the user selection of the range name in a combo box with a list of range names.

I have already named the ranges I need in the target Excel sheet as follows :

range1 (where range1 =$A$1:$E$10

range2 = $H$1:$L$10 and so on

The combo box control...