ExcelBanter - Summing to cells using VBA

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Summing to cells using VBA (https://www.excelbanter.com/excel-programming/386781-summing-cells-using-vba.html)

Carlee

Summing to cells using VBA

Hello

Question: How can i sum B63 + B64, placing the total in B66, using VBA?
The sheet name is 'Monthly Summary'
--
Carlee

Vergel Adriano

Summing to cells using VBA

One way is like this

With Worksheets("Monthly Summary")
.Range("B66").Value = .Range("B63").Value + .Range("B64").Value
End With

--
Hope that helps.

Vergel Adriano

"Carlee" wrote:

Hello

Question: How can i sum B63 + B64, placing the total in B66, using VBA?
The sheet name is 'Monthly Summary'
--
Carlee

All times are GMT +1. The time now is 11:38 AM.