Adding value of two cells to get result in 3rd cell

[DocAElstein]

Did you realise and understand that your macro was incorrect? The issue was that you were using an incorrect macro. The macro was incorrect. Your formula was incorrect. The macro in your uploaded workbook was incorrect. So it did not work for me for that reason.
Your macro was using "E2" which was incorrect. You should have been using "E3"
In your uploded workbook, your data was in row 3 , so you must use B3 and E3. Your macro was using B3 and E2. That was the problem.

[Anshu]

Yes Sir! I've realised the mistake immediately after seeing your code. And I'm thankful that the mistake was highlighted properly with red color to bring to my notice.
But, actually, that was typed E2 instead of E3 just by mistake. The real problem is something else. Because even after correcting the code, it did not work for me.
As shown in the image, the cell C8 remain empty always for me.
Annotation 2020-08-26 205837.jpg

Before posting my problem here and tips.net, I've searched a lot and try many codes, but nothing works. One of the code, I tried was-

Sub Addition()

Dim Add As Integer
Dim var1 As Integer
Dim var2 As Integer
var1 = Range("B3").Value
var2 = Range("E3").Value
Add = var1 + var2
Range("C8").Select
ActiveCell.FormulaR1C1 = Add

End Sub


But it, too, failed to work for me.
2nd.jpg


Then only I reached to the conclusion that the problem may be somewhere else!