Hi I have a range to sort,but I need sort key to be dynamic,
so in "my version I am attempting to take range from variables firstrow and jobcol, not quite working
thks


Standard:
Range("D117:T1328").Select
Selection.Sort Key1:=Range("T117"), Order1:=xlDescending, Header:=xlGuess _
, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

My Version:
Range("D117:T1328").Select
Selection.Sort Key1:=Cells(firstrow,jobcol), Order1:=xlDescending, Header:=xlGuess _
, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal