View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default 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.)