Add string to array

[XLnew]

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

 

[blutfort]

Is this what you are after?

**********************************
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.

 

[XLnew]

Hello,

Thanks a lot. That solved the problem
Thanks for the quick solution.

Best,

XLNew