How to check for an empty cell

**Turtleman10** · 10-25-2012, 03:38 PM

How would I check to see if a cell is empty?

**jeffreybrown** · 10-25-2012, 03:41 PM

One way

=Len(A1)=0

**HSV** · 10-25-2012, 03:45 PM

Another.
=isblank(a1)

**Turtleman10** · 10-25-2012, 03:49 PM

so If I wanted to go down a coulmn I would probably nee a dountil and a isblank does that sound right.

**Turtleman10** · 10-25-2012, 04:23 PM

Did you mean isEmpty?

**HSV** · 10-25-2012, 04:28 PM

In Dutch is it: =ISLEEG(A1)
In English: =ISBLANK(A1)

**Turtleman10** · 10-25-2012, 04:31 PM

When I put that in I get he error Sub or Function not defined

**HSV** · 10-25-2012, 04:42 PM

I'm sorry Turtleman10,
For Vba it is: ISEMPTY(Range("A1"))

**Turtleman10** · 10-25-2012, 04:42 PM

OK so here is my code so far my problem is when it gets to an empty cell it doesnt stop.

Please Login or Register  to view this content.

**Turtleman10** · 10-25-2012, 04:45 PM

No problem HSV you pointed me in a direction and thats what I needed.

**HSV** · 10-25-2012, 04:52 PM

Please Login or Register  to view this content.

**Turtleman10** · 10-26-2012, 08:32 AM

That worked thanks.

Re: Empty cell