Littlemalky
Board Regular
- Joined
- Jan 14, 2011
- Messages
- 223
I have a filter in ascending order in column "E". I need a statement that if there is a negative number or multiple negative numbers in that column after i sort it (they will be at the top), then i need my cursor to select the first non-negative cell in that column, otherwise do nothing.
There may or may not be negative numbers in the cell, and there will most likely be zeros, but not always. If there is a zero, I'm considering that a positive number in this case and then that would be the first cell to be selected. It just can't be negative. My purpose for this is that I need to copy everything down from the first "positive" number.
There may or may not be negative numbers in the cell, and there will most likely be zeros, but not always. If there is a zero, I'm considering that a positive number in this case and then that would be the first cell to be selected. It just can't be negative. My purpose for this is that I need to copy everything down from the first "positive" number.