In any case, in this piece what is it doing? Is it offset from "C" 1
column? So the sum
function is reading the C range one cell at a time and if there is a value
in the next column it sums it? Please let me know if I am correct.
TIA,

set streams_needed = Intersect(range("H12:h64000"), ActiveSheet.UsedRange)


For each C in Streams_needed
DCT= Application.worksheetfunction.sumif(streams_needed .offset(0,1),
c.offset(0,1) value, streams_needed)

If c.formula like "=sumif*" then
if C.Value 40 then
c.font.bold = true
c.font.colorindex = 3

end if
end if
Next C

That's what it looks like to me.

But unless you're doing something special, this line:

If c.formula like "=sumif*" then
will most likely fail

I'd check to see if that cell contains a formula (not text) and then make sure I
used the right case for =SUMIF(.



Janis wrote:

In any case, in this piece what is it doing? Is it offset from "C" 1
column? So the sum
function is reading the C range one cell at a time and if there is a value
in the next column it sums it? Please let me know if I am correct.
TIA,

set streams_needed = Intersect(range("H12:h64000"), ActiveSheet.UsedRange)

For each C in Streams_needed
DCT= Application.worksheetfunction.sumif(streams_needed .offset(0,1),
c.offset(0,1) value, streams_needed)

If c.formula like "=sumif*" then
if C.Value 40 then
c.font.bold = true
c.font.colorindex = 3

end if
end if
Next C

--

Dave Peterson