SortField.Key (Excel)

Specifies the range that is currently being sorted on.

The key can either be a range name (String) or a Range object.

Dim rngKey As Range
Set rngKey = ActiveSheet.Sort.SortFields(1).Key