I have always used "vbCR" instead of "vbCRLF". Does the
"vbCRLF" add an additional line feed??
-----Original Message-----
Joe

In XL2003 this worked

Sub test()
ActiveCell.Value = "Ben" & Chr(10) & "Hur" & Chr(10) &
"Gladiator"
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England



"Joe" wrote in message
...
I am using XL 2002. I need to populate cells with data
that has been
created using the vbcrlf constant (i.e. data value = "Ben"
& vbcrlf & "Hur"
& vbcrlf & "gladiator").

When I populate the cell with the data value above it
appears double
spaced, like this:

Ben

Hur

gladiator

I want it to apepar like this:

Ben
Hur
gladiator

What is the vb constant used to create the Alt+Enter
line break while
populating a cell?

TIA,
--
Joe

VBA Automation/VB/C++/Web and DB development


.