| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Set row height, but allow wrap text | Excel Discussion (Misc queries) | |||
| Need help setting row height with wrap text. | Excel Discussion (Misc queries) | |||
| Text won't wrap if row height is over 200 | Excel Worksheet Functions | |||
| row height not accounting for wrap text | Excel Discussion (Misc queries) | |||
| Wrap text & row height | Excel Discussion (Misc queries) | |||
Threaded Mode
