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