do while not isempty(cel1)
activecell.offset(1, 0).activate
loop
-----Original Message-----
I'm trying to identify cells that are not empty.
However, when using
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 can
you get it to identify the 0 as < empty?
Thanks!
--
jtrevill
----------------------------------------------------------
--------------
jtrevill's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=16601
View this thread:
http://www.excelforum.com/showthread...hreadid=315002
.