将数字转换为日期格式dd / mm / yyyy在列中直到空单元格

So I have got the below code working for a specific range of cells. But I want the macro to work for different range sizes. I basically need the code to go through each cell until it reaches an empty cell. The second part of the code I have been able to do this, but changing the first half is a bit more tricky. Can anyone help?So I have got the below code working for a spec