|
Posted to microsoft.public.excel.programming
|
|
|
Looking for < empty cells
Hi
use
activecell<""
"jtrevill" wrote:
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...o&userid=16601
View this thread: http://www.excelforum.com/showthread...hreadid=315002
|