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