按每列为单位排序 Sub WeiKua() Dim ArrYS, ArrJG, i%, j%, k%, Temp ArrYS = Range("D3:R202") ReDim ArrJG(1 To UBound(ArrYS, 1), 1 To 4) For i = 1 To UBound(ArrYS, 1) k = 0 For j = 1 To UBound(ArrYS, 2) If Len(ArrYS(i, j)) > 0 Then If k = 0 Then Temp = j Else ArrJG(i, k) = j - Temp Temp = j End If k = k + 1 End If Next j Next i Range("T3:W202") = ArrJG '以下为排序 For j = 1 To 4 For i = 1 To UBound(ArrJG, 1) For k = i + 1 To UBound(ArrJG, 1) If ArrJG(k, j) > ArrJG(i, j) Then Temp = ArrJG(i, j) ArrJG(i, j) = ArrJG(k, j) ArrJG(k, j) = Temp End If Next k Next i Next j Range("Y3:AB202") = ArrJG End Sub |