橫向排序求助

yjq2006

excel里如何實現橫向由小到大排序?

請大俠編程實現!



謝謝!

guzhen9315

Sub 宏1()

' 橫向由小到大排序


    Range("A1:J1").Select
   
    Selection.Copy
   
    Range("AA1").Select
   
    Selection.PasteSpecial Paste:=xlAll, Operation:=xlNone, SkipBlanks:=False _
        , Transpose:=True
   
    Application.CutCopyMode = False
   
    Selection.Sort Key1:=Range("AA1"), Order1:=xlAscending, Header:=xlGuess, _
        OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, SortMethod _
        :=xlPinYin
   
    Selection.Copy
   
    Range("A1").Select
   
    Selection.PasteSpecial Paste:=xlAll, Operation:=xlNone, SkipBlanks:=False _
             , Transpose:=True
   
    Range("AA1:AA20").Select
   
    Application.CutCopyMode = False
   
    Selection.ClearContents

End Sub




不知道,行不行?

橫向数据如果在 A1:J1,共十个;

列AA,是空闲的列.

方漠

对当前光标所在的行进行横向排序。

Sub SortByRow()
'**********************
'  2006-11-21 Aaron
'**********************
Dim Ld(1 To 255) As Variant, I, J As Integer
Dim Mvalue As Variant, MI As Integer, Crow As Long, Ccol As Integer

Crow = ActiveCell.Row                            'Get current row no.
Ccol = Cells(Crow, 255).End(xlToLeft).Column     'Get urrent row range last column no.

For I = 1 To Ccol - 1
    Mvalue = Cells(Crow, I).Value                     'Save first cell value to variant
    MI = I                                            'Save column no. to variant
   For J = I + 1 To Ccol
      If Cells(Crow, J).Value < Mvalue Then            'if latter cell value less than var Mvalue, replace it
         Mvalue = Cells(Crow, J).Value
         MI = J
       End If
   Next J
   Cells(Crow, MI).Value = Cells(Crow, I).Value       'exchange the minimal cells' value
   Cells(Crow, I).Value = Mvalue
Next I

If Len(Cells(Crow, 1)) = 0 Then
   Range(Cells(Crow, 1), Cells(Crow, Cells(Crow, 1).End(xlToRight).Column - 1)).Delete Shift:=xlToLeft   'Delete blank cell in head column
End If

End Sub