Find last non-blank cell in a column then used it as Start of a range

Hi experts,

I found a code in the internet which allows me to change the data in column L into Proper Case; however, the code looks thru the whole column every time i have to run it.

Is there a way I can have it look into the last non empty cell in column L then do whatever it does starting from there?

So if i update the sheet today and the last non empty cell in column L is L1294 (based from a previous update) then the code would read starting from L1295 going down or starting from the latest non empty cell (ex. L1305) and stopping at L1295?

I figure i can put in a formula in cell to find the last non empty cell then reference the code in that cell but i couldn't incorporate it in the code.

Please help.

Thanks man. I figured i need to speed up the macro as well..thanks for the code it works