K kaja48380 Feb 27, 2008 #1 hi i like to add the two cells by using macro and to display the result in other cell
J JE McGimpsey Feb 27, 2008 #2 One way: Public Sub Add2Cells() Range("C1").Value = Range("A1").Value + Range("B1").Value End Sub