本帖最后由 过江龙 于 2011-12-8 16:57 编辑
在宏“插入合计行”中增加对12月份的判断:
X = [A65536].End(xlUp).Row
If X > 1 Then
If Month(Cells(X, 1)) = 12 Then
Cells(X + 2, "b") = "本年累计"
Cells(X + 2, "d").Formula = "=SUMPRODUCT((A2:A" & X & "<>0)*d2:d" & X & ")"
Cells(X + 2, "e").Formula = "=SUMPRODUCT((A2:A" & X & "<>0)*e2:e" & X & ")"
Cells(X + 1, "b") = "本月合计"
Cells(X + 1, "d").Formula = "=SUMPRODUCT((MONTH(A2:A" & X & ")=12)*d2:d" & X & ")"
Cells(X + 1, "e").Formula = "=SUMPRODUCT((MONTH(A2:A" & X & ")=12)*e2:e" & X & ")"
End If
End If因为内置函数Month的参数为0话,它的返回值是12,
|