Hello

The line
DESCTY =OFFSET(DesReg_Start,(MATCH(FreightCalculator!$A$14,DesReg_Column,0)-1),1,COUNTIF(DesReg_Column,FreightCalculator!$A$14),1)

is not VBA. It is the way I defined the named range in Excel so it is a dependent drop down list

I am using VBA to assign the named range to the activex control