VBA Variable Array Name?

Question

I would like to know if there a way to change array names while looping.

for example

For i= 1 to 4
    "array" & i()
Next i

array1 ,array2,array3,array4 are my 4 arrays.

Thanks

You can use double-dimensional arrays - msdn.microsoft.com/en-us/library/d2de1t93(v=vs.90).aspx - and then you can just change an index of required array easily. — GSazheniuk
– GSazheniuk, Commented Oct 1, 2015 at 17:51
Any time you find yourself needing to change the names of your variables is the time to re-think your approach. If you really need to do this then consider storing your arrays in a Scripting Dictionary object with the "names" as keys. — Tim Williams
– Tim Williams, Commented Oct 1, 2015 at 18:04
If you edit this question to where it is clear what you're trying to do. (Code sample doesn't even seem to be trying to do anything useful) someone may be able to give you an alternative. As it is though, it's unclear what you're asking. — Daniel
– Daniel, Commented Oct 1, 2015 at 18:06
Ok, I have 4 different arrays and i want to use the longest array among these 4 arrays. so how do i get the longest array name?. — Shan
– Shan, Commented Oct 1, 2015 at 18:14
If you use an array of arrays then you can loop over them and pick the largest one. — Tim Williams
– Tim Williams, Commented Oct 1, 2015 at 21:17

SierraOscar · Accepted Answer · 2015-10-01 18:00:54Z

1

To quote my favourite StackOverflow answer:

Short Answer: No.
Long Answer: Noooooooooooooo.

answered Oct 1, 2015 at 18:00

SierraOscar

17.7k6 gold badges44 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1