I had one question, how do i plus a number from excel cell for example A1.

A1 number is now 30, if i add a code in visual basic by clicking a command button, it will add 1 to 31. (excel97)

Solved: Private Sub Button1_Click() Range("A1").Activate ActiveCell.Value = ActiveCell.Value + 1 End Sub