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