VBA - Cells

  • Thread starter Thread starter Jerome Patrick Webb
  • Start date 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!
 
Yes: CHR(10)

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

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

.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get a macro to run on all files in a folder and save each one? 0
Modify Recorded Macro 1
Run-Time error '9' Subscript out of Range 7
Run Time error 1004 - Pastespecial method of range class failed. 3
Find sometimes ignores Application.FindFormat 3
Using Sheets.Add after and want to keep a sheet as the first sheet 2
keep getting the error message - Compile error: Else without If 2
piece of code keeps failing.... 2

Back
Top