Copying a Collection

[VeryNewbie2004]

I have a collection which is being returned from a public property of a class module. Compiling this collection takes in the region of one second to run.

My problem is that I want to refer to the collection a number of times within the same sub routine and naturally don't want to collate the collection everytime I want to refer to it.

Is there a way I can copy the collection to a local version or can anyone suggest any other way I can speed things up.

Thanks In Advance

 

[neilharris]

you should be able to do the following:

dim colDestination as collection
set colDestination = SourceClass.SourceProperty

Where SourceClass.SourceProperty is your class and property.