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&_

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&_

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&_