Thread
:
sum function
View Single Post
#
2
Posted to microsoft.public.excel.programming
[email protected]
external usenet poster
Posts: 113
sum function
Hi,
try this :
Sub SUMMING()
Dim oEnd As Object, r
Set oEnd = Range("A65536").End(xlUp)
r = oEnd.Row + 1
Range("A" & r).Formula = "=sum(a1:a" & oEnd.Row & ")"
End Sub
Rgds,
Halim
menuliskan:
hi all,
i need help on how to put a sum function at the end of the last (rigth
end ) column.
follow the number for the macro sequence of where the data is input.
| 1 | 2 |
| 1 | 2 |
| 1 | 2 |
| 1 | 2 |
| 1 | 2 |
| 1 | 2 |
| 1 | 2 |
| 1 | 2 |
| 1 | 2 |
3(sum of all 1) 4(sum of all 2)
after each run of the macro there is a new colomn of data and a new
sum
thx for the help in advance
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]