I want a cell to be populated with words in other cells to create a list like this: "Apple, Pear, Banana, ETC...." I have created code that I am pretty sure will do this but it is very long and very messy. The one cell is being populated by multiple cells which hold a different word e.g a different fruit name. I need an Array which puts them all into the same cell separated with a comma. "lngWriteRow" can be ignored for now this just tells the code to input the list in the next empty row of column "E". Here is the code I have currently come up with:
Bookmarks