xdragon 发表于 2014-8-20 22:04
可以的,把Application.InputBox("请选择源区域", "温馨提示", , , , , , 8)改成selection,就是对选中区域 ...
大师,你太强大了。这样吗?
Sub 原地倒序()
Dim arr, i&, j%, brr()
arr = Selection
ReDim brr(1 To UBound(arr), 1 To UBound(arr, 2))
For i = 1 To UBound(arr)
For j = 1 To UBound(arr, 2)
brr(UBound(arr) - i + 1, UBound(arr, 2) - j + 1) = arr(i, j)
Next
Next
Selection.Resize(UBound(arr), UBound(arr, 2)) = brr
End Sub
|