A zero in a cell is classed as an empty cell???? 1

[LeighAnne]

I am writing some VBA that contains the loop:

Do Until ActiveCell.Value = Empty
-
-
-
-
Loop

Unfortunately when the activecell value is "0", then "activecell.value = Empty" is true. How can this be correct? If there is a zero in the cell then it is not empty, it contains a zero. How can I rewrite this so that it checks if the cell is truly blank i.e. contains no data?

 

[Molby]

Try

Do until Trim(activecell.value) = ""

Loop

 

[GlennUK]

Or use :

Do until ActiveCell.Formula = Empty
.
.
.
Loop

Cheers, Glenn.

My grandfather was ill, and my grandmother smeared goose-grease on his back. He went downhill very quickly after that.

 

[LeighAnne]

Thanks Molby,

That worked a dream!

Le