| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
|
#4
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I shift the contents of the cells up to remove empty cells. | Excel Discussion (Misc queries) | |||
| Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
| When I SUM cells & 1 is empty I need the result to be empty not 0 | Excel Discussion (Misc queries) | |||
| How can I convert empty strings to empty cells? | Excel Discussion (Misc queries) | |||
| Can blank cells created using empty Double-Quotes not be empty?? | Excel Programming | |||
![jtrevill[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
