|
发表于 2017-6-5 09:50
|
显示全部楼层
本楼为最佳答案
- Sub loarr()
- Dim arr, brr, i%, j%
- arr = Range("a1").CurrentRegion
-
- If [h1] > UBound(arr) Then Exit Sub
-
- [j1].CurrentRegion.ClearContents '清屏
-
- ReDim brr(1 To [h1], 1 To UBound(arr, 2))
-
- For i = UBound(arr) - [h1] + 1 To UBound(arr)
- For j = 1 To UBound(arr, 2)
- brr(i - UBound(arr) + [h1], j) = arr(i, j)
- Next j
- Next i
-
- [j1].Resize(UBound(brr), UBound(brr, 2)) = brr
-
- '刷格式
- Range("a1:e1").Copy
- Range("j1").CurrentRegion.PasteSpecial xlPasteFormats
-
- End Sub
复制代码 |
评分
-
查看全部评分
|