looping through records of left column until cell is empty

Hey all,

I created a macro. But Problem is that I'm not sure how I can it perform functions until the A column is empty. Ideally it would be nice to have something like:

Please Login or Register  to view this content.

This below correctly fills in column b, c, and d based on the contents of column a:

Please Login or Register  to view this content.

Now is there a way to make this loop so it fills in B2, C2, and D2 based on contents of A2. And then fills in B3, C3, and D3 based on contents of A3. And so on.

Thanks for response.