summing in vba
 

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

summing in vba
 

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.


"Joseph Atie" wrote:

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

summing in vba
 

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

"Joseph Atie" wrote:

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

summing in vba
 

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

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


"JLGWhiz" wrote:

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.


"Joseph Atie" wrote:

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

summing in vba
 

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" wrote:

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

"Joseph Atie" wrote:

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

summing in vba
 

Then post the code you have so someone can help.

"Joseph Atie" wrote:

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" wrote:

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

"Joseph Atie" wrote:

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

summing in vba
 

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

Sum(Range("F2":F"



"JLGWhiz" wrote:

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.


"Joseph Atie" wrote:

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