|
楼主 |
发表于 2012-7-9 19:43
|
显示全部楼层
fjmxwrs 发表于 2012-7-9 19:39
把代码中相应的表名换成你改后的表名即可。
提示了无效的过程调用或参数
Sub 合并()
ARR1 = Sheets("Data").Range("B2:Q" & Range("A65536").End(xlUp).Row) '获得数据
ReDim ARR11(1 To UBound(ARR1), 1 To 14) '定义新数组
For I = 1 To UBound(ARR1) '循环复制
ARR11(I, 1) = ARR1(I, 1) & "-" & ARR1(I, 14) '新批号
For j = 2 To 5
ARR11(I, j) = ARR1(I, j)
Next j
ARR11(I, 6) = Mid(ARR1(I, 5), 1, InStr(ARR1(I, 5), "户") - 1) '提取简称
ARR11(I, 7) = ARR1(I, 6)
For j = 8 To 12
ARR11(I, j) = ARR1(I, j)
Next j
ARR11(I, 13) = ARR1(I, 15) '业务员
'ARR11(I, 14) = ARR1(I, 16) '日期
Next
With Sheets("简化")
.Rows("2:65536").ClearContents '清除内容
.Range("A2").Resize(UBound(ARR11), UBound(ARR11, 2)) = ARR11 '粘贴
End With
End Sub
我把上面的就改了两个表名,别的没动
|
|