Apparently Simple Question
Hi
Sub Test()
With Sheets(1).Range("A1")
.WrapText = True
.Value = "Hi Mom" & Chr(10) & "This is great" & _
Chr(10) & Chr(10) & "James"
End With
End Sub
Manually it's done with Alt Enter.
HTH. Best wishes Harald
"exceller" skrev i melding
...
I have a lot of experience with Excel and Excel VBA, but I can't figure
out
something that should be really simple. How do you go to/create a new line
in
a cell? Say you're typing text in a cell, and then you want to make a new
paragraph or put in some bullets IN THE SAME CELL, how is this done?
(I know it can be done by inserting new rows or going to the next cell,
but
this is cumbersome and requires constant updating to cell formatting.)
|