|
file:///C:\Documents and Settings\Administrator\Application Data\Tencent\Users\25362660\QQ\WinTemp\RichOle\99C4Y9~15%2(IC37T)8LSHU.jpg请教标题有合并单元格的工资条作法,谢谢
- Sub Macro1()
- Dim arr, rng As Range, i&, s&, x%, y&
- Sheets(1).Activate
- Sheets(2).Cells.Clear
- Set rng = [a1:l4]
- arr = Range("a5:l" & Range("a65536").End(xlUp).Row)
- x = UBound(arr, 2): y = rng.Rows.Count: s = 1
- For i = 1 To UBound(arr)
- rng.Copy Sheets(2).Cells(s, 1)
- Cells(i + 4, 1).Resize(1, x).Copy Sheets(2).Cells(s + y, 1)
- s = s + y + 2
- Next
- Sheets(2).Activate
- End Sub
复制代码
|
|