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
HIS


"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