Excel VBA not incrementing the value of a specific cell. Function SayIt(cell1 As Variant, Optional baSync As Boolean, Optional bPurge As Boolean) ThisWorkbook.Worksheets("Latest").Activate Dim Roll As Integer, result2 As String Roll = ThisWorkbook.Worksheets("Latest").Range("d2").Value ' The value of cell D1 is currently 1 MsgBox "Sayit Before ROLL " & Roll Roll = Roll + 1 MsgBox "Sayit After ROLL " & Roll End Function
Solved by A. U. in 20 mins