If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Sorting Data

Thread starter Dummy Excel
Start date Jun 30, 2008

Dummy Excel

Well-known Member

Jun 30, 2008

Hi All,

I have some data with a total at the bottom. I need to sort my data without including the totals row
my code is:

Code:

    ActiveWorkbook.Worksheets("STORE SUMMARY").Sort.SortFields.Clear
    ActiveWorkbook.Worksheets("STORE SUMMARY").Sort.SortFields.Add Key:=Range("K:K") _
        , SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
    With ActiveWorkbook.Worksheets("STORE SUMMARY").Sort
        .SetRange Range("A1").CurrentRegion
        .Header = xlYes
        .MatchCase = False
        .Orientation = xlTopToBottom
        .SortMethod = xlPinYin
        .Apply
    End With

any ideas?
thanks
Sam