Pass ComboBox Value X Rows Down From Chosem Item

I have a series of integer constants defined for the column offset to be applied based on the category selected by the user; there are 16 in total.

e.g.

Const Transfer_Offset As Integer = 19

Using concatenate and replace i have a variable named Column_Offset that = the string value of constant variables defined.

e.g. Column_Offset would contain the value Transfer_Offset

what I ams struggling to do, is to get the variable Column_Offset to contain the value of Transfer_Offset i.e 19

Ultimately this value would then be used in an activecell.offset(0, Column_Offset) to move the cell address to the required.

At present, using the above code gives me an error as VBA only goes down one level in the tier of variables and thus tries to offset the active cell by Transfer_Offset, not 19 columns as required.