I've never noticed this before, but the Key argument of the Add method for a collection is not case sensitive. That is, this throws an error: Sub testcollection()
Dim col As Collection
Set col = New Collection
col.Add "me", "me"
col.Add "Me", "Me"
End [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2009/02/27/collections-can-be-so-insensitive/
Posted
Feb 27 2009, 03:32 PM
by
Daily Dose of Excel