SUM() Problem
 

Trying to make a subtotal appear in a nearby row as part of a loop. This code
doesn't work:

Set rngFirst = Range("X" & intEmpRowCount)
Set rngLast = Range("X" & intEmpRowCount + intCounter - 1)
rngWorkCell(1 + intCounter - 1, 26).Value = Sum(rngFirst, rngLast)

...and, so now what do I do?
--
Dave
Temping with Staffmark
in Rock Hill, SC

SUM() Problem
 

.... = Worksheetfunction.Sum(rngFirst, rngLast)
--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Dave Birley" wrote:

Trying to make a subtotal appear in a nearby row as part of a loop. This code
doesn't work:

Set rngFirst = Range("X" & intEmpRowCount)
Set rngLast = Range("X" & intEmpRowCount + intCounter - 1)
rngWorkCell(1 + intCounter - 1, 26).Value = Sum(rngFirst, rngLast)

..and, so now what do I do?
--
Dave
Temping with Staffmark
in Rock Hill, SC

SUM() Problem
 

Well, that go rid off the error, so thanks. The bad news is that Cells when
rngFirst is X2 and rngLast is X10, X5, X9 and X10 each containing a value of
1.0, the resultant i receive is 1.0, not 3.0.

Whussup?
--
Dave
Temping with Staffmark
in Rock Hill, SC


"Wigi" wrote:

... = Worksheetfunction.Sum(rngFirst, rngLast)
--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Dave Birley" wrote:

Trying to make a subtotal appear in a nearby row as part of a loop. This code
doesn't work:

Set rngFirst = Range("X" & intEmpRowCount)
Set rngLast = Range("X" & intEmpRowCount + intCounter - 1)
rngWorkCell(1 + intCounter - 1, 26).Value = Sum(rngFirst, rngLast)

..and, so now what do I do?
--
Dave
Temping with Staffmark
in Rock Hill, SC

SUM() Problem
 

I sed a function very simialr to that today. Try
WorksheetFunction.Sum(Range(rngFirst, rngLast)).

"Dave Birley" wrote:

Well, that go rid off the error, so thanks. The bad news is that Cells when
rngFirst is X2 and rngLast is X10, X5, X9 and X10 each containing a value of
1.0, the resultant i receive is 1.0, not 3.0.

Whussup?
--
Dave
Temping with Staffmark
in Rock Hill, SC


"Wigi" wrote:

... = Worksheetfunction.Sum(rngFirst, rngLast)
--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Dave Birley" wrote:

Trying to make a subtotal appear in a nearby row as part of a loop. This code
doesn't work:

Set rngFirst = Range("X" & intEmpRowCount)
Set rngLast = Range("X" & intEmpRowCount + intCounter - 1)
rngWorkCell(1 + intCounter - 1, 26).Value = Sum(rngFirst, rngLast)

..and, so now what do I do?
--
Dave
Temping with Staffmark
in Rock Hill, SC

SUM() Problem
 

Thanks -- that there done did da dirty deed!
--
Dave
Temping with Staffmark
in Rock Hill, SC


"Sam" wrote:

I sed a function very simialr to that today. Try
WorksheetFunction.Sum(Range(rngFirst, rngLast)).

"Dave Birley" wrote:

Well, that go rid off the error, so thanks. The bad news is that Cells when
rngFirst is X2 and rngLast is X10, X5, X9 and X10 each containing a value of
1.0, the resultant i receive is 1.0, not 3.0.

Whussup?
--
Dave
Temping with Staffmark
in Rock Hill, SC


"Wigi" wrote:

... = Worksheetfunction.Sum(rngFirst, rngLast)
--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Dave Birley" wrote:

Trying to make a subtotal appear in a nearby row as part of a loop. This code
doesn't work:

Set rngFirst = Range("X" & intEmpRowCount)
Set rngLast = Range("X" & intEmpRowCount + intCounter - 1)
rngWorkCell(1 + intCounter - 1, 26).Value = Sum(rngFirst, rngLast)

..and, so now what do I do?
--
Dave
Temping with Staffmark
in Rock Hill, SC