AW: Grösseren Bereich Sortieren
05.10.2006 14:53:13
Rudi
Hallo,
nicht sehr elegant, klappt aber.
In ein Modul, Bereich markieren und laufen lassen:
Sub tt()
Dim c As Range, rng As Range, n As Long
Dim wks As Worksheet, tmp As Worksheet
Set wks = ActiveSheet
Set rng = Selection
Set tmp = Worksheets.Add
For Each c In rng.Cells
tmp.Cells(65536, 1).End(xlUp).Offset(1, 0) = c.Value
Next
With tmp
.Range(.Cells(2, 1), .Cells(65536, 1).End(xlUp)).Sort .Range("A2"), xlAscending, , , , , , xlNo
End With
n = 2
For Each c In rng
c = tmp.Cells(n, 1)
n = n + 1
Next
Application.DisplayAlerts = False
tmp.Delete
Application.DisplayAlerts = True
End Sub
Gruß
Rudi