Sub Region_Sort_Subtotal()
Application.ScreenUpdating = False
With ActiveCell.CurrentRegion
'convert text dates to serial dates
.Range("H1:H" & .Rows.Count).TextToColumns Destination:=.Range("H1"), _
DataType:=xlFixedWidth, FieldInfo:=Array(0, 3), TrailingMinusNumbers:=True
.Range("H1:H" & .Rows.Count).NumberFormat = "dd-mmm-yy"
.Sort Key1:=Range("D2"), Order1:=xlAscending, Key2:=Range("H2"), _
Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1, _
MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal, DataOption2:=xlSortTextAsNumbers
.Subtotal GroupBy:=4, Function:=xlSum, TotalList:=Array(5), _
Replace:=True, PageBreaks:=False, SummaryBelowData:=True
End With
Application.ScreenUpdating = True
End Sub
Bookmarks