What are you using, Chr(10)?

--
__________________________________
HTH

Bob

"Maggie" wrote in message
...
Hi,

I am writing a macro to fill in a worksheet with multiple columns but in
the
top part, I need the text to appear across all of the columns but not go
off
the page. When I insert a hard return, it wraps the text within the width
of
the cell the text is in regardless of the location of the hard return. Any
help would be greatly appreciated!