how would i remove all elements from a variable set as new collection?

erase expects an array.

--


Gary

Set your collection to nothing and then re-create it...

Dim col As Collection

Set col = New Collection
col.Add Sheet1, Sheet1.Name
col.Add Sheet2, Sheet2.Name
col.Add Sheet3, Sheet3.Name

MsgBox col.Item(Sheet2.Name).Name
Set col = Nothing
Set col = New Collection

--
HTH...

Jim Thomlinson


"Gary Keramidas" wrote:

> how would i remove all elements from a variable set as new collection?
>
> erase expects an array.
>
> --
>
>
> Gary
>
>
>
>

thanks jim, works for me.
--


Gary


"Jim Thomlinson" <James_Thomlinson@owfg-Re-Move-This-.com> wrote in message
news:7F8F81CD-68E5-4F55-ADA4-(E-Mail Removed)...
> Set your collection to nothing and then re-create it...
>
> Dim col As Collection
>
> Set col = New Collection
> col.Add Sheet1, Sheet1.Name
> col.Add Sheet2, Sheet2.Name
> col.Add Sheet3, Sheet3.Name
>
> MsgBox col.Item(Sheet2.Name).Name
> Set col = Nothing
> Set col = New Collection
>
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Gary Keramidas" wrote:
>
>> how would i remove all elements from a variable set as new collection?
>>
>> erase expects an array.
>>
>> --
>>
>>
>> Gary
>>
>>
>>
>>

Set the collection variable to Nothing. E.g.,

Set MyCollection = Nothing


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Gary Keramidas" <GKeramidasATmsn.com> wrote in message
news:(E-Mail Removed)...
> how would i remove all elements from a variable set as new collection?
>
> erase expects an array.
>
> --
>
>
> Gary
>
>
>