I need vba to search down a column from cell D1 to the end of the data. The length of the column of data varies. I need the first cell that is non-negative and no parenthesis.
Below is a sample column. I need to start the search with the cell below C and then select the cell with 0.026.
<tbody>
</tbody>
Below is a sample column. I need to start the search with the cell below C and then select the cell with 0.026.
C |
-3 |
-3 |
-3 |
-2 |
-2 |
(0.023) |
0.026 |
0.0367 |
0.04 |
0.05 |
0.051 |
0.052 |
0.055 |
0.106 Thanks Tom |
<tbody>
</tbody>