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:
But this gives errorws.Range("A527:A544" & ws.Range("A527").End(xlDown).Row).ClearContents
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!