Can I build variable names in a VBA loop?

]Hi Everyone
Another sort of INDIRECT() query please.

I want to build variable names dynamically within a loop and then use them as variables.
For example VarName1, VarName2,VarName3 etc.

I have seen suggestions that I could use arrays such as VarName(1), VarName(2) etc.

The twist in the tail is that I also want to dynamically build the array variable names and then use them - so to access element 1 of the different arrays:
VarName1(1), VarName2(1), VarName3(1).

How can a string be evaluated as a variable and can this be done in VBA please?

Any code examples gratefully received.

as ever TIA

barry

You could add variables to a collection or dictionary. If a collection, you would reference the variable by index, if a dictionary, by key.

See the VB Language Reference for both objects. The latter requires a reference to Microsoft Scripting Runtime for early binding.

All that said, in most cases I can imagine, there is a better, simpler way.

Use a 2 dimensional array.

VarName(1,1), VarName(2,1), VarName(3,1)