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!