I was wondering if there is a way to make multiple lines in a cell using
visual basic. I know that in excel you can press ALT+ENTER and do this, but
I cannot figure it out using visual basic. Thanks in advance.
Jim

How about something like this
Cells(1, 1).Value = "first line text" & Chr(10) & "second line text"
Paul D

"Jim Peterson" wrote in message
...
I was wondering if there is a way to make multiple lines in a cell using
visual basic. I know that in excel you can press ALT+ENTER and do this,
but
I cannot figure it out using visual basic. Thanks in advance.
Jim

Hit ALT+ENTER


-----Original Message-----
How about something like this
Cells(1, 1).Value = "first line text" & Chr(10) & "second
line text"
Paul D

"Jim Peterson" wrote in message
. ..
I was wondering if there is a way to make multiple
lines in a cell using
visual basic. I know that in excel you can press
ALT+ENTER and do this,
but
I cannot figure it out using visual basic. Thanks in
advance.
Jim




.

activecell.Value = "ABCD" & chr(10) & "CDEF"

format the cell to wrap text.

--
Regards,
Tom Ogilvy



Jim Peterson wrote in message
...
I was wondering if there is a way to make multiple lines in a cell using
visual basic. I know that in excel you can press ALT+ENTER and do this,
but
I cannot figure it out using visual basic. Thanks in advance.
Jim