Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Do you mean this?

for each c In oRange.CellFormatRanges
    if (c.Value < -climit) or (c.Value > climit) then
        checkResult = checkResult + 1
    endif
next c

Do you mean this?

for each c In oRange.CellFormatRanges
oRange
    if (c.Value < -climit) or (c.Value > climit) then
        checkResult = checkResult + 1
    endif
next c