HV_L
05-30-2019, 02:04 AM
Hi,
I have a userform where multiple selections are checked.
I need to write that selected items to another sheet, and first emty the values in that range
I tried this:
ws.Range("A527:A544" & ws.Range("A527").End(xlDown).Row).ClearContents
But this gives error
Below this range is more, so cannot clear everything downwards
Actually the range is this much rows, but also the column C (where financial values are written manually) needs to get emptied. (Column B is not used so can be in the range)
How can I do this?
Thanks!
I have a userform where multiple selections are checked.
I need to write that selected items to another sheet, and first emty the values in that range
I tried this:
ws.Range("A527:A544" & ws.Range("A527").End(xlDown).Row).ClearContents
But this gives error
Below this range is more, so cannot clear everything downwards
Actually the range is this much rows, but also the column C (where financial values are written manually) needs to get emptied. (Column B is not used so can be in the range)
How can I do this?
Thanks!