excel - 对单元格 E1 + F1 求和并将答案放在 E1 中？这可能吗？

Question

我目前的项目有问题。我正在尝试将当前金额添加到新月份的先前金额。将 E1 + F1 相加并将答案插入 E1。这可能吗？

标签： excelvba

Answer 1

Option Explicit

Sub test()

    'I declare variable as double because your values may have decimals
    Dim dbE1 As Double, dbF1 As Double, dbTotal As Double

    With ThisWorkbook.Worksheets("Sheet1")

        'In my opinion is better to pass the values in variables before you change anything in case you want to use them again
        dbE1 = .Range("E1").Value
        dbF1 = .Range("F1").Value
        dbTotal = dbE1 + dbF1

        .Range("E1").Value = dbTotal

    End With

End Sub