On Sat, 21 Jan 2006 23:00:10 -0500, "Tom Ogilvy" wrote:

In this case, you don't need to loop if you only want all the cells (n2:n50)
to be empty as the second condition
If Range("n1").Value < "" And Application.CountA(Range("n2:n50")) = 0 Then
item = 1

That's true.

I was being more general and neglected to focus on the OP's issue.
--ron