David, I've spent time in the past in an exercise much as you've described. I actually did work out something one time, but it did not work with Proportional Width fonts. Which means that HOOD and ILLS may contain the same number of characters, but some letters are wider than others. MM has an additional problem. According to his attached example, he's not putting the paragraph in a single sell. Not only is his paragraph in successive rows, he has not merged the cells in adjacent columns, so he's allowing the first line to overflow the cell and into the next 5 or 6 cells. I posted a suggestion about merging the cells and getting the row height to adjust. hopefully, that solves his problem.
Paul ----------------------------------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ----------------------------------------- ________________________________ From: David Grugeon <da...@grugeon.com.au> To: excel-macros@googlegroups.com Sent: Wed, August 15, 2012 3:06:05 AM Subject: Re: $$Excel-Macros$$ Please help (Word Wrap in Excel)..... Hi Muneer In essence this is almoost impossible. The width of each letter varies so if you type iiiiiiii and mmmmmmmm they each contain the same number of characters but the width of each is very different. The only way I know of to work out how much of a particular string will fit in a given cell width is by accessing the font table which is part of each font. As far as I know there is no way to access this from within excel so you are down to writing a program in C to do it. In theory you could start with a string which overfilled the cell, having set the cell to wordwrap and autoheight. you could test its height until it held only one line of text.while you deleted characters one at a time from the end of the string. It would be a slow process as you would need to redisplay the screen after each letter was chopped off. Then you could put the balance of the string in the next cell down ad start again on that cell. This could not be reasonably done as you typed. It would have to be done, at the earlies, when you pressed enter to complete the cell.Then you would be locked out of the spreadsheet for a time until the program had done its thing. It would probably be better to do all the typing just not minding that you were overfilling the cells and then have a button to run the macro to do the line breaks. By the way this method would not work on merged cells. If you subsequently wanted to change what had been entered this would cause a lot of problems. I have no idea what you mean in your first condition. What do you mean by a "train" Is this the first condition or is it a test to be carried out after the text has been split into separate cells? What do you want to happen if the "train" would otherwise cross the page break? Do you want to delete any excess text? Do you want to go to the top of the next column on that page? Blow a whistle to alert the user? Move to the next sheet? increase the column width and try again? (incidentally determining where page breaks will occur is very difficult in Excel unless you predetermine that there will be a set number of rows/columns on each page.) As you can see there are a lot of problems in this exercise which is probably why you have had little response as yet. I do not have the skills to do this using the font tables method and do not want to spend the time doing it in excel as I suspect it would be unsatisfactory anyhow. Word might be a better program to use for your purpose. Perhaps putting your data into a table. Woird is much better at wrapping text than Excel is. RegardsDavid Grugeon -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
