Hi
I am using the following piece of code to assign a text to a cell.

Cells(row, col).Value = GetAttribValue(objAttrib, strAttribName)

The function GetAttribValue returns a simple VB string that contains
some vbCrLf 's (new line characters).

I find that the text that actually gets displayed in the cell actually
contains some extra vbCr or vbLf characters inserted just before the
original vbCrLf. I am not sure how excel inserts these extra
characters by itself.

How can I avoid this problem.

Thanks for any help.

Regards
Nitesh Gupta


--
xgnitesh
------------------------------------------------------------------------
xgnitesh's Profile: http://www.excelforum.com/member.php...o&userid=23874
View this thread: http://www.excelforum.com/showthread...hreadid=375150