And it's not really testing for emptiness.

The cell could be empty or it could even contain a giant formula that evaluates
to "".

=if(a3=7,"",sum(x9:x22))

When a3 = 7, the .value = "".

(and a single quote (') would qualify, too.)

If you really want empty:

if isempty(cell) then



David McNally wrote:

how does the for each cell in range synax work? I have the
following
For Each Cell In Range("I3:I9")
If Cell.Value = "" Then
'code
Next cell
which is saying that cell is empty? thanks so much

--

Dave Peterson