sum by coding

K

kaja48380

hi
i like to add the two cells by using macro and to display the result
in other cell
 
J

JE McGimpsey

One way:

Public Sub Add2Cells()
Range("C1").Value = Range("A1").Value + Range("B1").Value
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell data entering slow! 0
Newbie Help - IF Yes No Function 0
Drop down list control value in vba 2
VBA Coding Help for Beginner 0
Controlling Cells included in a sum command 3
VBA word change keys 0
Getting the formula right 5
Formatting question: how to format duration (time spent)? 0

Top