Data Sort based off of columns numbers stored in varibales

[mmetzinger]

Ok, so here is a fun one. My boss gave me the task of writing a macro that needs to be completely dynamic. The problem I have run into is when I want to sort the data on a sheet I need the sort procedure to be able to sort based of stored values instead of like "B2","B20".

What I have right now is:

Dim FirstCellSort As String
FirstCellSort = CallTypeColumn & ",2"
Dim LastCellSort As String
LastCellSort = CallTypeColumn & "," & LastCell

        ActiveWorkbook.Worksheets("Raw Data").Sort.SortFields.Clear
        ActiveWorkbook.Worksheets("Raw Data").Sort.SortFields.Add Key:=Range(FirstCellSort, LastCellSort _
            ), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
........

The variables have the following stored values:
FirstCellSort = "4,2"
LastCellSort = "4,20"

This does not work I believe because I am not using a reference like "D2" but instead referencing it as "4,2"

Can anyone help me out?!