What is the Chr() code for Alt+Enter in a cell when entering text?
Try
"Line1" & vbcrlf & "Line2"
for one line space or
"Line1" & vbcrlf & vbcrlf & "Line2"
and so on,
Regards,
Alan.
"Dennis" wrote in message
...
What is the Chr() code for the combination Alt+Enter in a cell when
entering text?
Would this work in VBA?
"Line 1 " & Chr(xxx) & Chr(xxx) & "Line 2 "
Yields:
Line 1
Line 2
|