|
发表于 2015-6-16 18:06
|
显示全部楼层
本楼为最佳答案
本帖最后由 qh8600 于 2015-6-16 18:07 编辑
cbce10 发表于 2015-6-16 17:40
请教该怎么写 - Sub demo()
- Dim ar(1 To 100000, 1 To 3), br, x, i, j, n
- n = 1
- ar(n, 1) = "购销合同类别": ar(n, 2) = "营销类别": ar(n, 3) = "折扣"
- For x = 1 To Sheets.Count
- If Sheets(x).Name <> "合并" Then
- br = Sheets(x).Range("a2:c" & Sheets(x).Cells(Rows.Count, 1).End(3).Row)
- For i = 1 To UBound(br)
- n = n + 1
- For j = 1 To 3
- ar(n, j) = br(i, j)
- Next
- Next
- End If
- Next
- Range("a1").Resize(n, 3) = ar
- End Sub
复制代码 楼主试试
表1.rar
(95.74 KB, 下载次数: 7)
|
|