I have two arrays, identicle in dimensions, identicle in size, exact same code pulling the data out of the arrays. The only difference is the amount of data in each and the data stored which does not matter. I want to create a loop that changes which array I am referencing in the VBA code each time through the loop. This will prevent an entire new section of code with the EXACT same code from the first array. I have attempted a few things but it appears you cannot set a variable to store a name and then use that name to access the data. Any thoughts... below is an quick example
Code:
dataL(50,50), dataF(50,50)
for i = 1 to # of arrays needed
if i = 1 then
arrayV = dataL
else
arrayV = dataF
end if
value = arrayV(1,1)
next i
so on so forth. That is a simple version of what I am trying to do, it is more detailed than that.