I am trying to create a loop that:

1. Starts on Sheet1 at cell A10 and loops down colum A until it finds and empty cell. Could somebody please point me in the right direction, I am starting to loose my mind.

Thank you in advance.
Simon.