Adding a collection to a wksht

[CLamar]

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

[Chip Pearson]

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" <CLamar@discussions.microsoft.com> wrote in message
news:B8C3A9BD-BFEC-4390-ACFC-8F323AD4BB81@microsoft.com...
>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