Hi,
Please help..
I am having trouble finding right code for my project. There are three rows. The third rows is empty. I need vba to evaluate B1, if less than 0, put an X in C1. Repeat on down until there isn't a value in column B.
<colgroup><col width="44" style="width: 33pt; mso-width-source: userset; mso-width-alt: 1609;">
<col width="43" style="width: 32pt; mso-width-source: userset; mso-width-alt: 1572;">
<col width="44" style="width: 33pt; mso-width-source: userset; mso-width-alt: 1609;">
<tbody>
</tbody>
Please help..
I am having trouble finding right code for my project. There are three rows. The third rows is empty. I need vba to evaluate B1, if less than 0, put an X in C1. Repeat on down until there isn't a value in column B.
1 | 75 | |
2 | 15 | |
3 | 0 | |
4 | 0 | |
5 | 0 | |
6 | 3 | |
7 | 0 | |
8 | 0 | |
9 | 0 | |
10 | 0 | |
11 | 0 | |
12 | 0 | |
13 | 0 | |
14 | 0 | |
15 | 0 | |
16 | 16 | |
17 | 84 | |
18 | 185 |