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!

Post your code...

Tim

"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!

try using merge across all the columns that you need

"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!