| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vb Code
I have the following code in my macro; however, I wish to place a space
between two fields: FirstName LastName. The data prints out "FirstNameLastName". Thanks for any help. ..Body = "text" $ cell.offset(0,-1).Value & cell.offset(0,-2)&vbNewline&vbNewline&_ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vb Code
Perhaps this...
..Body = "text" $ cell.offset(0,-1).Value & " " & cell.offset(0,-2)&vbNewline&vbNewline&_ -- HTH... Jim Thomlinson "Excel Help!" wrote: I have the following code in my macro; however, I wish to place a space between two fields: FirstName LastName. The data prints out "FirstNameLastName". Thanks for any help. .Body = "text" $ cell.offset(0,-1).Value & cell.offset(0,-2)&vbNewline&vbNewline&_ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vb Code
Worked Great! Looking for the hard answer. Thanks
"Jim Thomlinson" wrote: Perhaps this... .Body = "text" $ cell.offset(0,-1).Value & " " & cell.offset(0,-2)&vbNewline&vbNewline&_ -- HTH... Jim Thomlinson "Excel Help!" wrote: I have the following code in my macro; however, I wish to place a space between two fields: FirstName LastName. The data prints out "FirstNameLastName". Thanks for any help. .Body = "text" $ cell.offset(0,-1).Value & cell.offset(0,-2)&vbNewline&vbNewline&_ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
| Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. | Excel Programming | |||
| Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
| Modification in the CODE to HIDE rows and columns that start with ZERO (code given) | Excel Programming | |||
| Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming | |||
Linear Mode
