ok, thanks bob, there will be an occasional negative number, too.

--


Gary


"Bob Phillips" wrote in message
...
Not a good idea as -1 and +1 =0.

Use

If Application.Countif(Range("C1:K1"),0) = Range("C1:K1").Cells.Count
Then
Msgbox "All zero"
End If

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
hit enter too fast. i was thinking of using application.sum. does this
make
sense?

--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
what's the best way to test a row, columns c through k to see if all the
values are zeroes?

--


Gary