|
Sub ccccccc()
Dim ret As String
Dim ret1 As String
Dim arr
Application.DisplayAlerts = False
ret1 = ThisWorkbook.Name
ret = ret & Left(ret1, 4) & Format(Mid(ret1, 6, 3) + 1, "00") & Right(ret1, 17)
Dim wb1 As Workbook, wb2 As Workbook
'打开工作簿后加如下代码
Set wb1 = Workbooks(ret)
Set wb2 = Workbooks(ret1)
wb2.Sheets("直接人工-调理品").[m8] = Application.Sum(wb1.Sheets("直接人工-调理品").Range("m8"), wb2.Sheets("直接人工-调理品").Range("f8"))
wb2.Sheets("直接人工-调理品").[m9] = Application.Sum(wb1.Sheets("直接人工-调理品").Range("m9"), wb2.Sheets("直接人工-调理品").Range("f9"))
wb2.Sheets("直接人工-调理品").[m10] = Application.Sum(wb1.Sheets("直接人工-调理品").Range("m10"), wb2.Sheets("直接人工-调理品").Range("f10"))
wb2.Sheets("直接人工-调理品").[m11] = Application.Sum(wb1.Sheets("直接人工-调理品").Range("m11"), wb2.Sheets("直接人工-调理品").Range("f11"))
wb2.Sheets("直接人工-调理品").[m12] = Application.Sum(wb1.Sheets("直接人工-调理品").Range("m12"), wb2.Sheets("直接人工-调理品").Range("f12"))
wb2.Sheets("直接人工-调理品").[m13] = Application.Sum(wb1.Sheets("直接人工-调理品").Range("m13"), wb2.Sheets("直接人工-调理品").Range("f13"))
wb2.Sheets("直接人工-调理品").[m14] = Application.Sum(wb1.Sheets("直接人工-调理品").Range("m14"), wb2.Sheets("直接人工-调理品").Range("f14"))
wb2.Sheets("直接人工-调理品").[m15] = Application.Sum(wb1.Sheets("直接人工-调理品").Range("m15"), wb2.Sheets("直接人工-调理品").Range("f15"))
wb2.Sheets("直接人工-调理品").[m16] = Application.Sum(wb1.Sheets("直接人工-调理品").Range("m16"), wb2.Sheets("直接人工-调理品").Range("f16"))
wb2.Sheets("直接人工-调理品").[m17] = Application.Sum(wb1.Sheets("直接人工-调理品").Range("m17"), wb2.Sheets("直接人工-调理品").Range("f17"))
wb2.Sheets("直接人工-调理品").[m18] = Application.Sum(wb1.Sheets("直接人工-调理品").Range("m18"), wb2.Sheets("直接人工-调理品").Range("f18"))
wb2.Sheets("直接人工-调理品").[m19] = Application.Sum(wb1.Sheets("直接人工-调理品").Range("m19"), wb2.Sheets("直接人工-调理品").Range("f19"))
wb2.Sheets("直接人工-调理品").[m20] = Application.Sum(wb1.Sheets("直接人工-调理品").Range("m20"), wb2.Sheets("直接人工-调理品").Range("f20"))
wb2.Sheets("直接人工-调理品").[m21] = Application.Sum(wb1.Sheets("直接人工-调理品").Range("m21"), wb2.Sheets("直接人工-调理品").Range("f21"))
wb2.Sheets("直接人工-调理品").[m22] = Application.Sum(wb1.Sheets("直接人工-调理品").Range("m22"), wb2.Sheets("直接人工-调理品").Range("f22"))
End Sub
这个是我弄的 代码 为什么运行下来是
本年累计预算
F
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
工作薄都打开了 怎么这样的错呢呢 我怎么检查呀? 是代码哪错了吗?
简化代码如下 - Sub ccccccc()
- Dim ret As String
- Dim ret1 As String
- Dim arr, R As Integer
- Application.DisplayAlerts = False
- ret1 = ThisWorkbook.Name
- ret = ret & Left(ret1, 4) & Format(Mid(ret1, 6, 3) + 1, "00") & Right(ret1, 17)
- Dim wb1 As Object, wb2 As Object
- '打开工作簿后加如下代码
- Set wb1 = Workbooks(ret).Sheets("直接人工-调理品")
- Set wb2 = Workbooks(ret1).Sheets("直接人工-调理品")
- For R = 8 To 22
- wb2.Cells(R, "M") = Application.Sum(wb1.Cells(R, "M"), wb2.Cells(R, "F"))
- Next
- End Sub
复制代码
|
|