this will put a test on a second line. But you need to have auto fit on or
set your row height to accomodate the number of lines you intend to use.
Otherwise, everything after the first line disappears.

Range("A1") = "This is" & vbLf & "a test"

"rodchar" wrote:

hey all,
is there a way in html to get the equivalent of an alt-enter in a cell that
acts as a carriage return within the cell. If i use the <br/ tag a new cell
in excel is generated and i don't want that?

thanks,
rodchar