View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Asci equivalent of soft return (alt+enter)

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

Regards,
Peter T



"Andibevan" wrote in message
...
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