Re: Textfeld-Inhalte zusammenfassen
30.09.2002 01:25:14
Burkhard W
HalloSub StringSortieren()
Dim Ze As Integer, Zem As Integer, Sp As Integer, I As Integer, A As String
Range("A1").Select
Selection.End(xlDown).Select
Zem = ActiveCell.Row
I = 0
For Ze = 2 To Zem
For Sp = 1 To 26
Cells(Ze, Sp).Select
A = ActiveCell
Cells(I + Zem + 1, 27).Select
ActiveCell = A
I = I + 1
Next Sp
Next Ze
Range("AA" & Zem + 1 & ":AA" & I + Zem).Select
Selection.Sort Key1:=Range("AA" & Zem + 1), Order1:=xlAscending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
Range("AA" & Zem + 1).Select
A = ActiveCell
For Ze = 3 To I
Range("AA" & Ze + Zem - 1).Select
If ActiveCell = A Then
ActiveCell = ""
Else
A = ActiveCell
End If
Next Ze
Range("AA" & Zem + 1 & ":AA" & I + Zem).Select
Selection.Sort Key1:=Range("AA" & Zem + 1), Order1:=xlAscending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
Range("AA" & Zem + 1).Select
Range("A1").Select
End
End Sub
Wollte eigentlich im Datenfeld sortieren, aber den Befehl zum Sortieren muss ich noch suchen.
So gings auf die schnelle
Gus BWE