Hi magicians,
I have the below code that finds the last cell in L and clears its contents.
What I want to do is find the last cell in L and clear contents upwards to the next gap.
For example, on the below, I want to clear contents 14:18 only. However, the values can be changeable and not always in the cells as listed below. Hence why I need to find the last active cell and then looking upwards (in the below case to 14) and only clearing that last batch of values.
I hope I've explained myself clearly enough - please let me know if you need any other info! Thanks!
I have the below code that finds the last cell in L and clears its contents.
VBA Code:
Range("L" & Cells(Rows.Count, "L").End(xlUp).Row).ClearContents
What I want to do is find the last cell in L and clear contents upwards to the next gap.
For example, on the below, I want to clear contents 14:18 only. However, the values can be changeable and not always in the cells as listed below. Hence why I need to find the last active cell and then looking upwards (in the below case to 14) and only clearing that last batch of values.
I hope I've explained myself clearly enough - please let me know if you need any other info! Thanks!