View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
xgnitesh[_2_] xgnitesh[_2_] is offline
external usenet poster
 
Posts: 1
Default new line character in cell


Hi Mangesh

Thanks for your interest.
However the code I am using is already posted:
Cells(row, col).Value = GetAttribValue(objAttrib, strAttribName)
I am simply assigning a string variable to a cell value. You may
consider this

Cells(1, 1).Value = "Hello" + vbCrLf + "World"

Put the above line of code in a button click or sheet load method. You
will see that there is an extra character vbCr inserted before the
actual vbCrLf

Nitesh


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