How can I determine if my collection is empty or not?

[TheRedCardinal]

I have a procedure that puts item numbers that need to be dealt with later into a collection.

Then it re-dims an array based on the size of that collection.

For the first time, there was nothing to be dealt with, and so my collection is empty (but has still been defined).

I have tried:

1. If Not Isempty(Collection)
2. If Not IsEmpty(Collection.AllItems)
3. If CountRows(Collection) > 0

But I get an error with each one.

Is there a better way to test the condition?

 

[RoryA]

If the collection has been initialized, you can test its Count property. Otherwise test if the variable Is Nothing.