|
楼主 |
发表于 2012-7-27 16:24
|
显示全部楼层
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Sub 按钮3_单击()
With ThisWorkbook.Sheets
For Each wb In Workbooks
If wb.Name <> ThisWorkbook.Name Then
For Each sh In wb.Sheets
sh.Copy After:=.Item(.Count)
Next
End If
Next
.Item(2).Activate
End With
Worksheets("2012.06").Range("D6:E20", "G6:H20").FormulaR1C1 = "=SUM('*'!RC)"
Worksheets("2012.06").Range("D22:E24", "G22:H24").FormulaR1C1 = "=SUM('*'!RC)"
Worksheets("2012.06").Range("D26:E28", "G26:H28").FormulaR1C1 = "=SUM('*'!RC)"
Worksheets("2012.06").Range("D30:E32", " G 30:h32").FormulaR1C1 = "=SUM('*'!RC)"
Worksheets("2012.06").Range("D33:I35").FormulaR1C1 = "=SUM('*'!RC)"
Worksheets("2012.06").Range("E37:E40").FormulaR1C1 = "=SUM('*'!RC)"
Worksheets("2012.06").Range("H37:H40").FormulaR1C1 = "=SUM('*'!RC)"
End Sub
这是实现复制粘贴并汇总的宏的代码,高手帮忙看看 |
|