checking in collections are empty 2

[Luis939]

I'm using a collection, however, if lets say the collection was declared but never assigned any other values, what would be the best way to detect that, I have

on error resume next
if mycollection(1) = Empty then msgbox "collection empty"

is this the best thing to do? so far this does work in my code, but i dont know if this is technically the correct way to do it, thanks!!

 

[SkipVought]

Hi,

Use a loop

iCount = 0
for each c on MyCollection
  iCount = iCount + 1
Next

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[Luis939]

Nice!!! THANKS!

 

[Zathras]

A little bit of over-kill there, Skip. All that's needed is:
[blue]

  If MyCollection.Count = 0 Then MsgBox "collection empty"

[/color]