|
试试能否满足你的需求- Sub 合并表格()
- Dim m As Integer
- Dim n As Long
- Dim o As Long
- For m = 3 To Worksheets.Count
- n = Sheets(m).[a1048576].End(xlUp).Row - 1
- o = Sheets(2).[c1048576].End(xlUp).Row
- With mycount
- mycount = Worksheets.Count - 1
- Sheets(m).Select
- Range("e2", "e" & n).Select
- Sheets("生产吨位").Select
- Range("B" & m - 1).Select
- Selection.Copy
- Sheets(m).Select
- Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlMultiply, _
- SkipBlanks:=False, Transpose:=False
- Range("c2", "p" & n).Select
- Range("c" & n).Activate
- Selection.Copy
- Sheets(2).Select
- Range("c" & o + 1).Select
- ActiveSheet.Paste
- End With
- Next
- MsgBox "工作簿里 " & mycount & " 张工作表已合并成功", vbInformation, "合并提示"
- End Sub
复制代码 |
|