|
本帖最后由 windimi007 于 2013-8-8 21:08 编辑
不喜欢复制粘贴,没有填充色没关系吧!请测试!{:1712:}- Sub test()
- Dim ar, br(1 To 100000, 1 To 9)
- Dim i As Long, j As Long, k As Long, l As Long
- ar = Sheet2.Range("A4:I" & Sheet2.Cells(Rows.Count, 4).End(3).Row)
- For i = 1 To UBound(ar)
- For j = 1 To ar(i, 9)
- k = k + 1
- br(k, 1) = "'" & Format(k, "00")
- For l = 2 To 9
- br(k, l) = ar(i, l)
- Next l
- Next j
- Next i
- With Sheet1.Cells(4, 1)
- .Resize(Rows.Count - 3, 9).Clear
- With .Resize(k, 9)
- .Value = br
- .Borders.LineStyle = xlContinuous
- .Cells.EntireColumn.AutoFit
- End With
- End With
- End Sub
复制代码 |
|