Sorting VBA Array On Worksheet On Two Columns?

I'm trying to sort an array which is of variable height/rows when put on a worksheet. I need to sort by column C ascending (smallest to largest) and then by column D ascending (oldest to newest). I tried recording a macro but the code is just junk.

Code:

Dim BookSPSortingWorksheet As Worksheet
Dim TR As Range
Set BookSPSortingWorksheet = ThisWorkbook.Worksheets.Add
Set TR = BookSPSortingWorksheet.Range("A1").Resize(UBound(array_book_SPNames), UBound(array_book_SPNames, 2))
TR = array_book_SPNames

Is there a way I can use the sort function like the below by indexing my TR range for columns 3 and 4?

Code:

TR.Sort key1:=TR, order1:=xlAscending, MatchCase:=False