VBA - Cells

  • Thread starter Jerome Patrick Webb
  • Start date
J

Jerome Patrick Webb

All,

Is there a way to cause line breaks in data that I am
entering into a cell? Partial code:

' New Equipment ID... create new work TERMID cell
Range("RESIDTERM").Offset(lOffEqmt, 10).Value = _
"******** SPACER ************" & _
"Term1 :" & _
Term & "--" & _
'Insert line break here?
"FMV Pct: " & _
FMVPct & "--" & _
'Insert line break here?
"FMV $: " & _
FMVDol & "--" & _
'Insert line break here?
"OLV Pct: " & _
OLVPct & "--" & _
'Insert line break here?
"OLV $: " & _
OLVDol & "--"
' Modify TERMID cell
With Range("RESIDTERM").Offset(lOffEqmt, 10)
.HorizontalAlignment = xlGeneral
.VerticalAlignment = xlBottom
.WrapText = True
.Orientation = 0
.AddIndent = False
.ShrinkToFit = False
.MergeCells = False
End With

Thanks for your assistance!
 
K

K Dales

Yes: CHR(10)

Range("RESIDTERM").Offset(lOffEqmt, 10).Value = _
"Term1:" & Term & "--" & CHR(10) & _
...
 
Top