Add string to array
Add string to array
(OP)
Hello All,
I am new to VBA, and have the following question:
I have an exsisting array A={1;2;3;4;5}
I would now want to add the string "e" to all elements of the array. i.e A={1y;2y;3y;4y;5y}.
How can I achieve this in VBA?
At the moment, for generating the array (row vector), I have a for loop - something like:
++++++++++++++++++++++++++++++++
For i As Double 1 To 5 Step 1
A=i
Next i
++++++++++++++++++++++++++++++++
Sorry if the question is real basic.
Thanks.
XLNew
I am new to VBA, and have the following question:
I have an exsisting array A={1;2;3;4;5}
I would now want to add the string "e" to all elements of the array. i.e A={1y;2y;3y;4y;5y}.
How can I achieve this in VBA?
At the moment, for generating the array (row vector), I have a for loop - something like:
++++++++++++++++++++++++++++++++
For i As Double 1 To 5 Step 1
A=i
Next i
++++++++++++++++++++++++++++++++
Sorry if the question is real basic.
Thanks.
XLNew





RE: Add string to array
CODE
Dim A as Variant
Dim e as String
Dim i as integer
A={1;2;3;4;5}
e="y"
for i = 1 to 5
A(i) = A(i) & e
next i
**********************************
At the point of exit, the Array A would contain the following...
A={"1y";"2y";"3y";"4y";"5y"}
Note: I've redimensioned the array as a variant, this allows you store the value of the concatenation back into the original array. I was a little unclear if this was your desired outcome or not.
RE: Add string to array
Thanks a lot. That solved the problem :)
Thanks for the quick solution.
Best,
XLNew