Thread: vb Code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Excel Help! Excel Help! is offline
external usenet poster
 
Posts: 26
Default 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&_