Using Wrap Text after setting Row Height

  • Thread starter Thread starter imstarboard
  • Start date Start date
I

imstarboard

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 <[email protected]>
 
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.
 
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.
 
Rows.Autofit

--
Regards,
Tom Ogilvy


[email protected] said:
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.
Click to expand...
 
Back
Top