Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Add string to array

Status
Not open for further replies.

XLnew

Computer
Joined
Dec 21, 2008
Messages
12
Location
US
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
 
Is this what you are after?
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.
 
Hello,

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

Best,

XLNew
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top