Adding a collection to a wksht
 

I have a collection that I created. I am trying to take that collection and
copy it to another worksheet starting at Cell A1. How can this be done, or
should I use another method other than a collection

Thanks
Clamar

Adding a collection to a wksht
 

You can just loop through the collection.


For N = 1 To Coll.Count
Cells(N, 1).Value = Coll(N)
Next N

where Coll is your collection object.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"CLamar" wrote in message
...
I have a collection that I created. I am trying to take that
collection and
copy it to another worksheet starting at Cell A1. How can this
be done, or
should I use another method other than a collection

Thanks
Clamar