코드로 sort 하기 : 7개의 컬럼으로 정렬

▶코드로 sort 하기 : 7개의 컬럼으로 정렬

    With fpSpread1

        .SortKey(1) = 1: .SortKeyOrder(1) = SortKeyOrderAscending
        .SortKey(2) = 2: .SortKeyOrder(2) = SortKeyOrderAscending
        .SortKey(3) = 3: .SortKeyOrder(3) = SortKeyOrderAscending
        .SortKey(4) = 4: .SortKeyOrder(4) = SortKeyOrderAscending
        .SortKey(5) = 5: .SortKeyOrder(5) = SortKeyOrderAscending
        .SortKey(6) = 6: .SortKeyOrder(6) = SortKeyOrderAscending
        .SortKey(7) = 7: .SortKeyOrder(7) = SortKeyOrderAscending

        fpSpread1.Sort -1, -1, -1, -1, SortByRow

    End With