Sub Sorter()
Dim iresult
'
' Sorter Macro
'
' Keyboard Shortcut: Ctrl+s
'
iresult = Sorter_2("F6:F59", "C6:C59", "E6:E59", "B6:B59", "B6:H59")
iresult = Sorter_2("N6:N59", "K6:K59", "M6:M59", "J6:J59", "J6:O59")
iresult = Sorter_2("T6:T59", "R6:R59", "S6:S59", "Q6:Q59", "Q6:V59")
'' ActiveWorkbook.Worksheets("Duebestand").Sort.SortFields.Clear
'' ActiveWorkbook.Worksheets("Duebestand").Sort.SortFields.Add Key:=Range( _
'' "F6:F59"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
'' xlSortNormal
'' ActiveWorkbook.Worksheets("Duebestand").Sort.SortFields.Add Key:=Range( _
'' "C6:C59"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
'' xlSortNormal
'' ActiveWorkbook.Worksheets("Duebestand").Sort.SortFields.Add Key:=Range( _
'' "E6:E59"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
'' xlSortNormal
'' ActiveWorkbook.Worksheets("Duebestand").Sort.SortFields.Add Key:=Range( _
'' "B6:B59"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
'' xlSortNormal
'' With ActiveWorkbook.Worksheets("Duebestand").Sort
'' .SetRange Range("B6:H59")
'' .Header = xlGuess
'' .MatchCase = False
'' .Orientation = xlTopToBottom
'' .SortMethod = xlPinYin
'' .Apply
'' End With
End Sub
Sub Utskrift()
'
' Utskrift Macro
' Utskrift
'
' Keyboard Shortcut: Ctrl+p
'
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _
IgnorePrintAreas:=False
End Sub
Function Sorter_2(Rng1 As String, Rng2 As String, Rng3 As String, Rng4 As String, Rng5 As String)
'
' Sorter Macro
'
' Keyboard Shortcut: Ctrl+s
'
ActiveWorkbook.Worksheets("Duebestand").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Duebestand").Sort.SortFields.Add Key:=Range( _
Rng1), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
xlSortNormal
ActiveWorkbook.Worksheets("Duebestand").Sort.SortFields.Add Key:=Range( _
Rng2), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
xlSortNormal
ActiveWorkbook.Worksheets("Duebestand").Sort.SortFields.Add Key:=Range( _
Rng3), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
xlSortNormal
ActiveWorkbook.Worksheets("Duebestand").Sort.SortFields.Add Key:=Range( _
Rng4), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("Duebestand").Sort
.SetRange Range(Rng5)
.Header = xlGuess
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
End Function
Bookmarks