new line character in cell
 

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

new line character in cell
 

Could you post your code, and some examples maybe.

Mangesh


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

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

new line character in cell
 

Use:
Cells(1, 1).Value = "Hello" + Chr(10) + "World"

Mangesh


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

new line character in cell
 

This is from the help:

vbCrLf Chr(13) + Chr(10) Carriage return–linefeed combination
vbCr Chr(13) Carriage return character
vbLf Chr(10) Linefeed character

Manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=37515

new line character in cell
 

Thanks Mangesh

This works fine:

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

Regards
Nitesh


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

new line character in cell
 

Thanks for the feedback.

Mangesh


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

new line character in cell
 

I just replied to a similar topic above before I noticed this one.
This KB article gives a good overview of the ins and ons of VB's text
constants:
http://support.microsoft.com/?kbid=211774

Also, VbLf = chr(10) if you want to use a constant instead.