lisarenae0561
New Member
- Joined
- Mar 15, 2012
- Messages
- 2
Please note: I've been researching this online for days and have found many threads with a similar issue relating to merged cells, but I'm not using merged cells, so haven't found a solution to this problem.
Version: <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
Excel 2003<o></o>
<o></o>
What I’m trying to do: <o></o>
Display all contents of cells containing lots of text without any manual adjustments.<o></o>
<o></o>
Problem: <o></o>
Excel can hold about 32,000 characters per cell but will only display about 1024 of them when using automated features like word wrap and autofit row height. I need to be able to view all contents of a cell without manual adjustments. Note that cells are formatted as General and none are merged.<o></o>
<o></o>
What happens when I go beyond the viewable limit:<o></o>
></o>
></o>
What I need:<o></o>
A macro that will enter a line break/feed every X number of characters (but won’t break in the middle of words) and will set the row height based on the number of characters in the cell (I’ll use trial & error to determine how many characters should equate to a certain row height). I want the macro to initiate upon exiting a cell only in certain columns.
I know how to open the Visual Basic Editor but would need to know whether to place the macro code in a new module or in ThisWorkbook.
Thank you in advance! If someone could solve this, it would help soooo many people!!
Version: <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>Excel 2003<o
></o><o
></o>What I’m trying to do: <o
></o>Display all contents of cells containing lots of text without any manual adjustments.<o
></o><o
></o>Problem: <o
></o>Excel can hold about 32,000 characters per cell but will only display about 1024 of them when using automated features like word wrap and autofit row height. I need to be able to view all contents of a cell without manual adjustments. Note that cells are formatted as General and none are merged.<o
></o><o
></o>What happens when I go beyond the viewable limit:<o
></o>- Word wrap stops wrapping after a certain amount of text. The text just goes off the right edge of the cell. I can still view all of the text in the formula bar when I click on the cell, but it won’t wrap anymore. I have to manually enter Alt + Enter to create line breaks/feeds in the cell.<o></o>
></o>- Autofit row height won’t adjust the height any taller after a certain point. Even when I manually create line breaks via the method above and double click the row divider to autofit row height, it won’t adjust any taller. I have to manually drag the row divider to display the remaining lines.<o></o>
></o>What I need:<o
></o>A macro that will enter a line break/feed every X number of characters (but won’t break in the middle of words) and will set the row height based on the number of characters in the cell (I’ll use trial & error to determine how many characters should equate to a certain row height). I want the macro to initiate upon exiting a cell only in certain columns.
I know how to open the Visual Basic Editor but would need to know whether to place the macro code in a new module or in ThisWorkbook.
Thank you in advance! If someone could solve this, it would help soooo many people!!
