help with hard return please
 

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!

help with hard return please
 

I've tried that and also Chr(13)...I don't really know what the difference
is. I haven't been doing this very long.

"Bob Phillips" wrote:

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!

help with hard return please
 

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!

help with hard return please
 

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!