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
|