本帖最后由 xdragon 于 2015-1-6 14:57 编辑
- Sub 向下对齐()
- Dim arr, col%, i%, irow%, re()
- arr = Range("A1").CurrentRegion.Value
- ReDim re(1 To UBound(arr), 1 To UBound(arr, 2))
- For col = 1 To UBound(arr, 2)
- i = UBound(arr)
- Do Until Len(arr(i, col))
- i = i - 1
- Loop
- For irow = i To 1 Step -1
- re(UBound(arr) - i + irow, col) = arr(irow, col)
- Next
- Next
- Range("A1").Resize(UBound(arr), UBound(arr, 2)) = re
- End Sub
复制代码 |