Access Accessing arrays within loop - VBA


Joined
May 19, 2013
Messages
2
Reaction score
0
I have 9 arrays (arr1....arr9) and 9 variables of type string (var1....var9). My question is how can I REDIM the arrays using a FOR-NEXT loop so that the number of elements of each array equals the length of its corresponding variable. I want to put the strings into arrays to speed-up my macro.
 
Ad

Advertisements

Joined
May 1, 2013
Messages
22
Reaction score
0
If I understand what you are trying to do correctly, the code is as follows:

Code:
Dim arr1(0) As String
 
Dim var1 As String
 
'some code here
 
ReDim Preserve arr1(0 To UBound(arr1()) + 1)
 
'more code here
I should add that this assumes that you are adding the variables in a specific order and, of course, validating that data at some point! This may not be exactly what you were asking but I think it should get the point across. Any questions, feel free to let me know.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top