how to get values in a collection of arrays in VBA

[Nihar1991]

Hi ,

can anyone help me with below query.

i have a collection of arrays. and i need to read the values.

eg:

Dim resColl As New Collection

resColl.Add Array(key, Key3("UserName"), Key3("Password"))

in above add method i added arrays with 3 elements. and after adding i need to read the vales.
but using for each loop i am unable to read the values which was added to the collection.

 

[StephenCrump]

It would help if you posted the rest of your code.

 

[Norie]

Why aren't you using keys when adding to the collection?