PrivateSubWorksheet_change(ByValTargetAsRange)
Dimtr,tc,k
tr=Target.Row
tc=Target.Column
k=Cells(65536,tc).End(xlUp).Row
Iftr3Andtc1AndtcMod2=1Then
Forn=2To240Step2
Sheets(1).Cells(2,n).Value=列和(k,n1)-列和(k,n)
Nextn
EndIf
EndSub
Function列和(r,c)
Dima
a=0
Forn=4TorStep1
a=aSheets(1).Cells(n,c).Value
Nextn
列和=a
EndFunction
|