I am working on the same problem. I got nowhere trying to substitute
the vbCrlf character in the string. That seems only to work if you
display the cell contents in a text box. I think what we need to do
is find a way to code the sequence of keystrokes that enters the
carriage return/line feed into the cell for display.
So how do we code the CTRL-ALT-ENTER keystrokes?
Regards,
Pat