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

--
jtrevil
-----------------------------------------------------------------------
jtrevill's Profile: http://www.excelforum.com/member.php...fo&userid=1660
View this thread: http://www.excelforum.com/showthread.php?threadid=31500