Update cell number

[rav295]

Hi,
I am a VBA beginner, how do i add a certain number to cell A1 from another cell? E.g. I want to add the number in cell E3 to cell A1, so the cell A1 gets updated. Heres a sample code i cant quite work:


Sub Count()
mycount = Range("a1") + 1
Range("a1") = mycount
End Sub

[Leith Ross]

Hello Rav295,

Here is how it is done. I am assuming both cells are on the same worksheet.

'E3 = 15
'A1 = 10

MyCount = Range("E3").Value
Range("A1").Value = Range("A1").Value + MyCount

Now A1 = 25

Easy once you know how,
Leith Ross

[rav295]

Hi,
Sorry i forgot to say, the cells are on different sheets. How do i go about that?

Thanks

[Leith Ross]

Hello Rav295,

Here is how it is done when the cells are on different sheets. Prefix the range with the worksheet name.

Assumptions
'Worksheets("Sheet1").Range("E3").Value = 15
'Worksheets("Sheet2").Range("A1").Value = 10

Code
MyCount = Worksheets("Sheet1").Range("E3").Value
With Worksheets("Sheet2").Range("A1")
.Value = .Value + MyCount
End With

Now Worksheets("Sheet2").Range("A1").Value = 25

If you have any other question, just ask.

Thanks,
Leith Ross