|
楼主 |
发表于 2021-1-21 14:24
|
显示全部楼层
源起:
数组内的值如何能带格式
http://club.excelhome.net/thread-1571172-1-1.html
把单元格装进数组内:
- Sub tt() '合并单元格暂时无法处理
- Dim rng As Range, r&, c&, i&, j&, k&, m&, n&
- Dim arr
- On Error Resume Next
- With Sheets("Sheet1")
- r = .[A65536].End(xlUp).Row
- ReDim arr(1 To r, 1 To 4)
- For i = 1 To 5
- For j = 1 To 4
- Set arr(i, j) = .Cells(i, j)
- Next
- Next
- Range("F1:I255").Clear
- For m = 1 To UBound(arr)
- For n = 1 To UBound(arr, 2)
- arr(m, n).Copy .Range("F6").Offset(m - 1, n - 1)
- Next
- Next
- arr(4, 3).Copy .Range("F1")
- End With
- End Sub
复制代码
|
|