String concatenation

[shishi]

Hi,

Is there a better way to concatenate strings in excel vba.
The below code is not giving me the desired results. Could you please
tell what could be the reason?

For i = 1 To nmodules

Sname = "START_" & Str(i)
MsgBox "The String is " & Sname
Next i

The result is
START_<space>1
START_<space>2 .....and so on

Excel is placing a space between the arguments. The desired results is
START_1, START_2 etc.

shi

 

[Chip Pearson]

Use

Sname = Sname & "START_" & Str(i) & ", "


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[shishi]

Hi Mr. Pearson,

I tried using the above solution, still the excel is placing a space
between START_ and 1. So I get results like START_ 1. Any more ideas??

Thanks,
Shi

 

[Jim Cone]

Shi,

I think Chip may have gone to dinner...

The "Str" function automatically adds a space to contain the sign of the number.
The "Cstr" function would work for you, however it is not required.
The "&" operator will convert the i variable to a string so,
assuming that Sname is a String...

Sname = "START_" & i

is all you need.

Jim Cone
San Francisco, USA



Hi,
Is there a better way to concatenate strings in excel vba.
The below code is not giving me the desired results. Could you please
tell what could be the reason?
For i = 1 To nmodules
Sname = "START_" & Str(i)
MsgBox "The String is " & Sname
Next i
The result is
START_<space>1
START_<space>2 .....and so on
Excel is placing a space between the arguments. The desired results is
START_1, START_2 etc.
shi