Macro Help Required - Run script until no more data in column. Possible loop needed?

Please take a moment to read the forum rules and amend your original post to include code tags.

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Select your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button).

Dom