Sorry for a double post, but I have another hurdle to jump regarding this issue.

The code works great, but I need to do a similar copy/paste to yet another workbook. This time, however, the first URL goes into a cell in column J(starting at J2) on a "Feed Columns" sheet of the "Buy_Addon_Template" workbook, and the rest of the URLs are copied into a single cell in column K(starting at K2) and each comma replaced by a pipe character "|" so that the URLs are separated by each other with the "|" character.