grf1973 发表于 2016-3-18 14:58
反正我这边运行没什么问题。
Dim w(1 To 65536), s%
Sub 导入文件()
Application.ScreenUpdating = False
Dim wb As Workbook, Sht As Worksheet, xRng As Range
arr = [a2:zz2]
ReDim brr(1 To 65536, 1 To UBound(arr, 2))
r = [a65536].End(3).Row + 1 '需要导入数据的起始行
红色的地方改了就提示 ReDim brr(1 To 65536, 1 To UBound(arr, 2))这句溢出,具体见附件
Dim w(1 To 65536), s%能否解释下这句的含义 |
|
|