abdelfattah
Well-known Member
- Joined
- May 3, 2019
- Messages
- 1,429
- Office Version
- 2019
- 2010
- Platform
- Windows
hello
i need adjusting my code i would sum only one time when run code not repeatedly every time it sum the values as in my code
thanks
i need adjusting my code i would sum only one time when run code not repeatedly every time it sum the values as in my code
VBA Code:
Sub sum_dynamic()
ir = Cells(Rows.Count, 1).End(xlUp).Row
Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Select
ActiveCell.Offset(0, 0).Value = "total"
ActiveCell.Offset(0, 1).Select
ActiveCell.Formula = "=sum(b2:b" & ir & ")"
End Sub