Adding a collection to a wksht

C

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
 
C

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
 
Top