Access nested collection with unique Key
Hi vba excel gurus,
i am unable to find syntax for accessing nested collection. I am adding the collection as follows
CurrentItem.Add wsSheet.Cells(rowTitle, clmMAT).Value, "MAT" 'Adding Temp Collection Values into Function Collection GetDetailUpdateData.Add CurrentItem 'adding collection into the collection.
how i can access the collection. ??
i am able to copy the collection into col but unable to access indivisual items
dim col as new collection
col.Item(Item("MAT")) ??
Plz help
Ramzan
|