Looking for <> empty cells

[jtrevill]

I'm trying to identify cells that are not empty. However, when usin
code such as the following (very simple)

Do until activecell <> empty
Activecell.offset(1,0).activate
Loop

and when searching cells that include 0, 0, 0, 30

It will skip over the 0's and stop at the cell with 30 in it. How ca
you get it to identify the 0 as <> empty?

Thanks

 

[Bob Phillips]

This works for you?

Do until activecell <> empty


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

do while not isempty(cel1)
activecell.offset(1, 0).activate
loop

 

[Guest]

Hi
use
activecell<>""