VBA gives several options:

IsEmpty function can test for truely empty.
You can also check for an entered zero.
You can also check for the presence of a formula that is currenly yielding
zero.
--
Gary's Student


"Lee" wrote:

I am new to programming and wonder if there is a way to check for a emty cell
( a cell that has the value of 0). I have a column B57:B76 I would like to
check if B57 has anything 0 if it does move to b58 and check if that is 0
and so on. When the program finds the first cell that is a emty cell, it then
used data on a other worksheet and the number in the last cell it checked for
the calculations to be placed in B77.

I think I could do it with if statements. I think it might be to long.

thanks for any help