Using Wrap Text after setting Row Height
 

Once I have set a row height manually, Excel seems to prevent me from
using "wrap text" ever again on that row. Is there a way to reset the
row height to be able to respond to setting "wrap text" to be on?

Thanks!

Tim

Using Wrap Text after setting Row Height
 

If the row height doesn't have to be a certain size I would recommend setting
it to auto fit row height, that way when it wraps the text it will adjust the
height on its own. Hope that was helpful.

" wrote:

Once I have set a row height manually, Excel seems to prevent me from
using "wrap text" ever again on that row. Is there a way to reset the
row height to be able to respond to setting "wrap text" to be on?

Thanks!

Tim

Using Wrap Text after setting Row Height
 

After you wrap text, just autofit the row height.

--
Regards,
Tom Ogilvy


" wrote:

Once I have set a row height manually, Excel seems to prevent me from
using "wrap text" ever again on that row. Is there a way to reset the
row height to be able to respond to setting "wrap text" to be on?

Thanks!

Tim

Using Wrap Text after setting Row Height
 

Well, here's the entire picture. I have a button on the form that
toggles word wrap on and off for the sheet. This allows people to see
all of the contents in the cells when they are looking at a particular
row, but see as many rows as possible when scanning the list.

I have written another macro to move data from one cell to append
another cell (that contains a history of what has been moved). When
doing so, I include a carriage return chr(13) for readability, but
when I do this, Excel automatically sets a new row height and in doing
so disables word wrapping. All I really want to do is prevent Excel
from tinkering with the row height, but I would settle for setting the
row height back myself (in VBA) if I could also re-enable word wrap.

Any thoughts?

Thanks.


On May 4, 11:39 am, Tom Ogilvy
wrote:
After you wrap text, just autofit the row height.

--
Regards,
Tom Ogilvy

Using Wrap Text after setting Row Height
 

Rows.Autofit

--
Regards,
Tom Ogilvy


" wrote:

Well, here's the entire picture. I have a button on the form that
toggles word wrap on and off for the sheet. This allows people to see
all of the contents in the cells when they are looking at a particular
row, but see as many rows as possible when scanning the list.

I have written another macro to move data from one cell to append
another cell (that contains a history of what has been moved). When
doing so, I include a carriage return chr(13) for readability, but
when I do this, Excel automatically sets a new row height and in doing
so disables word wrapping. All I really want to do is prevent Excel
from tinkering with the row height, but I would settle for setting the
row height back myself (in VBA) if I could also re-enable word wrap.

Any thoughts?

Thanks.


On May 4, 11:39 am, Tom Ogilvy
wrote:
After you wrap text, just autofit the row height.

--
Regards,
Tom Ogilvy