|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
Range复制到数组的应用。
- Sub M()
- Dim Sht As Worksheet, Rng As Range
- Dim Rr, Rrr, Cc, Ccc
- Dim Arr
- Dim ii, jj, jj1
- 'Arr = Array("兰州", "珠海", "武汉", "北京", "抚远", "漠河", "三沙", "喀什")
- 'Arr = rArr(Array("兰州", "珠海", "武汉", "北京", "抚远", "漠河", "三沙", "喀什"))
- Set Sht = Sheet1
- Set Rng = Sht.Range("B1:I1")
- Cc = 1
- Rrr = 20
- Arr = RngToArr(Sht.Range("B1:I1"))
- ''
- For ii = 0 To UBound(Arr)
- For jj = 0 To UBound(Arr)
- Sht.Cells(Rrr + ii, jj + 2) = Arr(ii, jj)
- Next jj
- Next ii
- End Sub
- Function RngToArr(Rng As Range)
- Dim Rr
- Rr = Rng.Columns.Count
- ReDim Arr(Rr - 1, Rr - 1)
-
- For jj = 1 To Rng.Columns.Count
- Cc = 0
- For jj1 = jj To Rng.Columns.Count
- 'Sht.Cells(Rr + jj, Cc + JJ1) = Rng(, cC)
- Set Arr(jj - 1, Cc) = Rng(, jj1)
- Cc = Cc + 1
- Next jj1
- For jj1 = 1 To jj - 1
- 'Sht.Cells(Rr + jj, Cc + JJ1) = Rng(, cC)
- Set Arr(jj - 1, Cc) = Rng(, jj1)
- Cc = Cc + 1
- Next jj1
- Next jj
- RngToArr = Arr
- End Function
复制代码
|
|