Thread: SUM() Problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Birley Dave Birley is offline
external usenet poster
 
Posts: 171
Default 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