Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
compare 2 column cells and return the adjacent columns cells data of the cell | Excel Worksheet Functions | |||
Cells won't change font color or show hi-lighted cells in document | Excel Discussion (Misc queries) | |||
display a range of cells editible cells based on matching date | Excel Worksheet Functions | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions |