稍微修改了一下
Private Sub CommandButton1_Click()
Dim n
n = [c65536].End(xlUp).Row + 1 '找出C列最后一个单元格的位置
Cells(n, 3) = "=SUM(B1:C" & n - 1 & ")" '对B,C两列求和,并写入C列最后一个单元格
Cells(n, 3) = Cells(n, 3) '把公式转化为数值
[f1] = "本月数据已累加"
End Sub
可以再进行简化
Private Sub CommandButton1_Click()
[f1] = "=SUM(B:C)" '对B,C两列求和
Cells([c65536].End(xlUp).Row + 1, 3) = [f1] '把数值,写入C列最后一个单元格
[f1] = "本月数据已累加"
End Sub
温馨提示:答案为网友推荐,仅供参考