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_<space1
START_<space2 .....and so on

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

shi