|
在thisworkbook里面粘贴
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Dim rn As Range
Dim m
m = 30 '//要计算的最后一列的行号
Set rn = Intersect(Union(Range("G6:G" & m), Range("I6:I" & m), Range("K6:K" & m), Range("M6:M" & m)), Target)
If Not rn Is Nothing Then
Cells(Target.Row, 4) = Cells(Target.Row, 7) + Cells(Target.Row, 9) + Cells(Target.Row, 11) + Cells(Target.Row, 13)
End If
Set rn = Intersect(Union(Range("H6:H" & m), Range("J6:J" & m), Range("L6:L" & m)), Target)
If Not rn Is Nothing Then
Cells(Target.Row, 5) = Cells(Target.Row, 8) + Cells(Target.Row, 10) + Cells(Target.Row, 12)
End If
End Sub
|
|