|
- Sub Greenhand()
- Dim i&, arr, brr()
- Application.ScreenUpdating = False
- arr = [c1].CurrentRegion.Value
- [f1].Resize(UBound(arr), 1) = arr
- ReDim brr(1 To UBound(arr), 1 To 1)
- For i = 1 To UBound(arr)
- If Right(arr(i, 1), 1) = "盈" Then
- brr(i, 1) = 2 * 10 ^ 4 + Split(Left(arr(i, 1), Len(arr(i, 1)) - 1), "-")(0) * 10 ^ 3 + _
- Split(Left(arr(i, 1), Len(arr(i, 1)) - 1), "-")(1) * 10 ^ 2 + Split(Left(arr(i, 1), Len(arr(i, 1)) - 1), "-")(2) _
- * 10 ^ 1 + Split(Left(arr(i, 1), Len(arr(i, 1)) - 1), "-")(3) * 10 ^ 0
- Else
- brr(i, 1) = 10 ^ 4 + Split(Left(arr(i, 1), Len(arr(i, 1)) - 1), "-")(0) * 10 ^ 3 + _
- Split(Left(arr(i, 1), Len(arr(i, 1)) - 1), "-")(1) * 10 ^ 2 + Split(Left(arr(i, 1), Len(arr(i, 1)) - 1), "-")(2) _
- * 10 ^ 1 + Split(Left(arr(i, 1), Len(arr(i, 1)) - 1), "-")(3) * 10 ^ 0
- End If
- Next
- [g1].Resize(UBound(arr), 1) = brr
- Range("f:g").Sort Key1:=Range("g1"), Order1:=xlAscending, Header:= _
- xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
- SortMethod:=xlPinYin, DataOption1:=xlSortNorma
- Columns("g:g").Clear
- Application.ScreenUpdating = True
- End Sub
复制代码 |
评分
-
查看全部评分
|