Hi everyone
hopefully this is a simple one but my limited VBA experience has me stumped. I want to clear the contents of columns a and b when a is blank. Below is the table of sample data i want to clear cells a4:b7, however this range need to be dynamic based off if column A is blank and b contains something.
<tbody>
</tbody>
hopefully this is a simple one but my limited VBA experience has me stumped. I want to clear the contents of columns a and b when a is blank. Below is the table of sample data i want to clear cells a4:b7, however this range need to be dynamic based off if column A is blank and b contains something.
a | b | |
1 | 1011111 | 500 |
2 | 1011157 | 500 |
3 | 1010257 | 500 |
4 | 500 | |
5 | 500 | |
6 | 500 | |
7 | 500 | |
<tbody>
</tbody>