Collection function

[ATLANTA]

Hi,
I am trying to figure out what a below function would be doing:

Public Function Clrclct(clct As Collection)
For i = 1 To clct.Count
clct.Remove 1
Next
End Function

I can only add that it's later being used while exporting tables from access to excel.


Will welcome and appreciate any ideas.

[ajetrumpet]

do you have any ideas for what it does?? Actually, it's pretty vague. Without seeing a big picture, providing an answer to something like this really seems strange.

[TheSmileyCoder]

It takes a collection and loops through it, clearing all items in that collection.

The name itself Clrclct i guess stands for something like Clear Collection.