Looking for < empty cells
 

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

Looking for < empty cells
 

This works for you?

Do until activecell < empty


--

HTH

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


"jtrevill" wrote in 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...o&userid=16601
View this thread: http://www.excelforum.com/showthread...hreadid=315002

Looking for < empty cells
 

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

.

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