I have merged several cells along one one (eg. A1 - E1). When I enter text
it will not wrap round (effectively resize the row). I have made sure that
"wrap text" is ticked in the options. Whatever I try, I can't get it to wrap
round - please help.

Taza

The text is wrapping but the row autofit won't function.

If cells are merged. the row will not autofit even with wrap text enabled
without using VBA

See google search thread for code by Greg Wilson

http://groups.google.com/group/micro...1c160cbeb27874


Gord Dibben MS Excel MVP

On Mon, 15 Jan 2007 09:57:00 -0800, Taza wrote:

I have merged several cells along one one (eg. A1 - E1). When I enter text
it will not wrap round (effectively resize the row). I have made sure that
"wrap text" is ticked in the options. Whatever I try, I can't get it to wrap
round - please help.

Thanks Gord

I had already put this code in, but no joy. I "right-clicked" the tab,
selected View Code and then pasted the VBA code into the box. I then just
closed the window.

I then entered test text into the merged cell - but no wrapping!!

Is there something else I need to do to make the VBA code work?

Thanks

"Gord Dibben" wrote:

Taza

The text is wrapping but the row autofit won't function.

If cells are merged. the row will not autofit even with wrap text enabled
without using VBA

See google search thread for code by Greg Wilson

http://groups.google.com/group/micro...1c160cbeb27874


Gord Dibben MS Excel MVP

On Mon, 15 Jan 2007 09:57:00 -0800, Taza wrote:

I have merged several cells along one one (eg. A1 - E1). When I enter text
it will not wrap round (effectively resize the row). I have made sure that
"wrap text" is ticked in the options. Whatever I try, I can't get it to wrap
round - please help.

Gord

Thanks for your help. Ignore my last posting, I've just got it to work -
Yippeeeeee.

However, I am then protecting the sheet (allowing entry only into selected
cells) - but the macro crashes with a failure "Run Time Error 1004 - Unable
to set MergeCells property of the Range class"

Selecting "Debug" highlights the following row in the code ma.MergeCells =
False.

I'm as lost as lost can be - any ideas at all?

Thanks.

"Gord Dibben" wrote:

Taza

The text is wrapping but the row autofit won't function.

If cells are merged. the row will not autofit even with wrap text enabled
without using VBA

See google search thread for code by Greg Wilson

http://groups.google.com/group/micro...1c160cbeb27874


Gord Dibben MS Excel MVP

On Mon, 15 Jan 2007 09:57:00 -0800, Taza wrote:

I have merged several cells along one one (eg. A1 - E1). When I enter text
it will not wrap round (effectively resize the row). I have made sure that
"wrap text" is ticked in the options. Whatever I try, I can't get it to wrap
round - please help.