summing in vba

[Joseph Atie]

im using excel to build a labour list from an ms project data file

the job im trying to do is sum column after i populate it using a pair of
for loops

so the only thing method i have of identifying the files i need to sum is
the counters of the loops.

I can do it via so more loops and an extra variable.

What i want to know is:

is there a simpler way to do it? perhaps an expression that i could use
something along the lines of:

cell.value = "=sum(counter:counter1)"

thanks in advance for any help

 

[JLGWhiz]

If you know the column that you are putting the data in, for instance, column
F, then you could use:

Sub addItup()
Dim mySum As Double
mySum = WorksheetFunction.Sum(Range("F2":F" _
& Range("F65536").End(xlUp).Row)
MsgBox mySum
End Sub

That would give you the sum of the values in column F as a dynamic range,
assuming a header row.

 

[JLGWhiz]

I might have left a bracket off. If so you will get a run time error. Just
add a parenthesis on the end.

 

[JLGWhiz]

I did miss one. Here is what it should be:

mySum = WorksheetFunction.Sum(Range("F2":F" _
& Range("F65536").End(xlUp).Row))

 

[Joseph Atie]

I dont actually know the column, its going to be done inside the loop. the no
of columns is limited by the no of shifts to be worked in the program.

It needs to actually work off the 2 counters, counter 1 = column, counter 2
= row

 

[JLGWhiz]

Then post the code you have so someone can help.

I dont actually know the column, its going to be done inside the loop. the no
of columns is limited by the no of shifts to be worked in the program.

It needs to actually work off the 2 counters, counter 1 = column, counter 2
= row

 

[JMay]

FWIW:
I don't see the need for the 2nd " (the one following F2)

Sum(Range("F2":F"