Try:


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

--
Gary's Student


"Andibevan" wrote:

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