Edgar,

You mean a part of the string on a new line in a cell? If so I discovered yesterday that you do this by inserting a Character(10) in your string. IMHO LibXL should have a more elegant way but I could not find it either.