|
如附件所示,,运行VB的时候提示下标越界。。。不知道什么原因,请老师帮忙看下。。麻烦了。
- Sub a()
- Dim i As Long, j As Long, sh As Worksheet, arr(1 To 10000, 1 To 4)
- Dim i1 As Long, i2 As Long
- With Worksheets("合并竖表")
- .Range("a1").CurrentRegion.ClearContents
- For Each sh In Worksheets
- If sh.Name <> "合并竖表" Then
- i = sh.[b65536].End(3).Row + 1
- j = sh.[iv1].End(xlToLeft).Column
- For i1 = 1 To i / 5
- For i2 = 2 To j
- k = k + 1
- arr(k, 1) = sh.Cells((i1 - 1) * 5 + 1, i2)
- arr(k, 2) = sh.Cells((i1 - 1) * 5 + 2, i2)
- arr(k, 3) = sh.Cells((i1 - 1) * 5 + 3, i2)
- arr(k, 4) = sh.Cells((i1 - 1) * 5 + 4, i2)
- Next i2
- Next i1
- .[a65536].End(3).Offset(1, 0).Resize(k, 4) = arr
- k = 0
- Erase arr
- End If
- Next sh
- .Rows(1).Delete
- End With
- End Sub
复制代码去掉ReDim arr(1 To i / 5 * j, 1 To 4),直接定义成一个足够大的数组arr(1 To 10000, 1 To 4)
|
|