This is driving me a bit nuts...seems like this should be really easy so I am trying to figure out the code on my own here.
I want to use the .Clear command to simply Clear a row if there are NO VALUES in columns A through I (there will be values in J and K that I want cleared if the condition that there are no values in A through I are met).
<tbody>
</tbody>
So I wrote a bunch of mumbo jumbo above - but you can see that I want to CLEAR the contents of rows 2 and 4 because those rows do not contain any values in columns A through I.
Is this a lot harder to do than I think it should be?
I want to use the .Clear command to simply Clear a row if there are NO VALUES in columns A through I (there will be values in J and K that I want cleared if the condition that there are no values in A through I are met).
A | B | C | D | E | F | G | H | I | J | K |
safsd | sfsd | sfsd | ||||||||
sdfs | sdfs | |||||||||
sdsd | sdsd | sdsd | ||||||||
sdsd | sdsd | |||||||||
sdsd | sds | sdsd |
<tbody>
</tbody>
So I wrote a bunch of mumbo jumbo above - but you can see that I want to CLEAR the contents of rows 2 and 4 because those rows do not contain any values in columns A through I.
Is this a lot harder to do than I think it should be?