I've sorted and removed duplicates from a range of names, then created a new collection to hold the data. Instead of putting the contents of the collection into a list box, I want to write it to a worksheet range. As far as I've gotten is:

Code:
For Each Item In NoDupes

NEED SOMETHING HERE----

ActiveCell.Offset(1, 0).Select
Next Item
Anyone know the code to take each item from the collection, paste it to a worksheet, then take the next item and paste it in the cell directly below the first?

DESPERATE FOR HELP HERE>>>>PLEASE RESPOND IF YOU HAVE A THOUGHT ON THIS