| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cocatenating two variables with a space in between
The below code does not work but I think I just need a small tweek.
Simply want to display the values of two variables in the same cell but with a space in between. ActiveCell.FormulaR1C1 = "=CONCATENATE(" & userMonthName & " " & userYearName & ")" Kind regards Khurram |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Space removal - a first name,space last name | Excel Discussion (Misc queries) | |||
| Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
| Passing Variable length Space Characters to Variables | Excel Programming | |||
| formula that will go up one space if no value in specified space | Excel Worksheet Functions | |||
| Paper Space / Model Space ? | Excel Discussion (Misc queries) | |||
Threaded Mode
