| 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 |
| 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)
Threaded Mode
