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.
a b
1 1011111 500
2 1011157 500
3 1010257 500
4 500
5 500
6 500
7 500
Bookmarks