|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub test()
- Dim r%, i%
- Dim arr, brr
- With Worksheets("sheet1")
- r = .Cells(.Rows.Count, 2).End(xlUp).Row
- arr = .Range("a1:AX1")
- For j = 1 To UBound(arr, 2)
- arr(1, j) = Int(Val(arr(1, j)))
- Next
- .Range("A" & r + 1 & ":" & "AX" & r + 1).Resize(1, UBound(arr, 2)) = arr
- .Range("a1:AX" & r + 1).Sort Key1:=Range("A" & r + 1), Order1:=xlOverThenDown, Header:=xlGuess, Orientation:=xlLeftToRight
- .Range("A" & r + 1 & ":" & "AX" & r + 1).Clear
- End With
- End Sub
复制代码 |
|