'Till the end of what row? By end, do you mean the end of a list, or the end of the sheet?
Do you know how to construct a FOR loop? Have you recorded the macro yet?
Record a macro of what you want and post it here, and we will help you build the loop!