sum a range in VBA
works fine
Thanks
"Striker" wrote in message
...
What is the proper way to find the sum of a range in VBA. Here is what I
have
Dim rRange as Range
Dim iLastRow as as long
Dim lSum as Long
lLastRow = Cells(Rows.Count, "A").End(xlUp).Row
Set rRange = Range ("A1:A" & lLastRow)
'Now I want to Sum rRange as they are all numbers? How do I do it. Say I
want to add the value to a Variable called lSum?
Thanks
|