Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding the first cell in column where value < 0
I looked in vba and I found that I could use the .find(), I was wondering if
there is a way I could look in the same group of cells for the first time the value is not equal to zero or "-" in the case of accounting format in the cell. Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding the first cell in column where value < 0
..find will find a specific value, well, it can included wildcards, too, but if
you want the first non-zero cell, I think you're going to have to loop through those cells. But if you're looking for other stuff, you may be able to use ..specialcells--this won't help you in this case, but it may sometime. WannaBeExceller wrote: I looked in vba and I found that I could use the .find(), I was wondering if there is a way I could look in the same group of cells for the first time the value is not equal to zero or "-" in the case of accounting format in the cell. Thanks in advance. -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding the first cell in column where value < 0
excel vba enters vba. i do not know how to recover from it. Can some
body assist.me! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding the first empty cell in a column | Excel Programming | |||
Finding the last non bank cell in a column | Excel Programming | |||
Finding Cell Interior Colour of First Cell in Column | Excel Programming | |||
Finding column of a particular cell | Excel Programming | |||
Finding the last used cell in a column | Excel Programming |