Asci equivalent of soft return (alt+enter)

[Andibevan]

Hi All,

What is the asci combination required to create the equivalent of pressing
alt+enter when in a cell?

I.e. I want to print the words "Cat" and "Mat" in the same cell but on
different lines using VBA?

TIA

Andi

 

[Guest]

Try:


Sub trial()
Cells(5, 1).Value = "Cat" & Chr(10) & "Mat"
End Sub

 

[Peter T]

With ActiveCell
..Value = "Cat" & vbLf & "Mat"
..WrapText = True ' normally done automaically
End With

Regards,
Peter T

 

[Andibevan]

Thank's

Try:


Sub trial()
Cells(5, 1).Value = "Cat" & Chr(10) & "Mat"
End Sub