Finding the last cell in a column

Hi guys - any one with a smart way to do this?

Am trying to write a program that will let me copy cells from a large table and paste into one long list.

Thanks!