| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
String concatenation
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Help With String Concatenation | Excel Worksheet Functions | |||
| Need Help With String Concatenation | Excel Worksheet Functions | |||
| Bold in string concatenation | Excel Discussion (Misc queries) | |||
| How do I put each member of string concatenation in its own line? | Excel Worksheet Functions | |||
| string concatenation | Excel Programming | |||
Threaded Mode
