Well, then it looks like we're back to David's comment. It's almost impossible to do.
There are WAY too many variables. Do we assume that if the cell above contains information then it is part of the same paragraph? We COULD assume a "base" character width based on font size. Then only allow X number of characters per line, regardless of whether it's close to the edge. If you increase the font size, then do you add rows and move the extra characters to the next line? If you reduce the font size, do you remove blank rows? At this point, it sounds like you're trying to make Excel do what Word does. perhaps someone else would be interested in tackling this. 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: Mohammed Muneer <mmun...@ccc.com.qa> To: excel-macros@googlegroups.com Sent: Wed, August 15, 2012 8:48:04 AM Subject: RE: $$Excel-Macros$$ Word Wrap in Excel..... Dear Paul, Your solution is good to some extent, but the thing is I don’t want to use the merge or any option that is default in excel. I need a vba coding to control the text flow unto the page break only, when one line is finish it should go to the another line. Urexample for merge and make the text to flow in a defined region is itself a good example, what I am trying to explain in the worksheet. Anyway I have done the major part of my work still part of it left undone, this I will complete it within two days. U know along with the line to line flow I need to justify the text written. Regards, Muneer, CC… I think part of the problem is that you're not using the proper terminology and are not describing your issue accurately. In addition, your examples do not demonstrate the problem. After spending WAY too much time trying to figure out what you're trying to do, I think I finally see your problem.... First of all.. "Word Wrap" is the ability for a SINGLE PARAGRAPH to "wrap" to an additional line within the same CELL when the sentence exceeds the with of the CELL. So... "Word Wrap" is a property assigned to a CELL or a group of MERGED CELLS. Not to a group of cells in different rows. (Unless, of course, you merge the rows, then it treats it as a single cell) So.. in column E, rows 11-15 you have: E11: To be held accountable for the construction of their work packages and tasks and ensure their E12: participation in implementing proper control for the completion of their scope of work within E13: budget and schedule. Each task controller and each work package supervisor is accountable E14: for his participation in cost control process in his area of work. This leads to more awareness, E15: economical working methods, and timely corrective actions. Excel doesn't have any way of knowing that the contents of the successive rows are part of the same "paragraph". Excel, by default, does not "break" a single row into two pages. So, the first thing you need to do is to put your entire paragraph into one cell. that means, you need to "merge" the cells in columns E-K (or E-L, if you're going to the edge) I would do this for all rows so that you can easily fill out future documents. Next.. Excel doesn't auto-fit row heights for merged cells. (which is unfortunate, it would make my life SO much easier) To get around that, what I've done is create another cell (off to the right) that is the same width as the combined cells you've merged. then, use the formula: =E# (i.e. =E11) to display the contents in this cell. You'll need to make sure the font size in this cell is the same as you're using in the document cells. You can hide this column so that it doesn't confuse people. This will cause the row height to adjust to the contents of the paragraph you insert. hopefully, the file I've attached will come across and show you what I mean. 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:Mohammed Muneer <mmun...@ccc.com.qa> To: excel-macros@googlegroups.com Sent: Tue, August 14, 2012 8:33:42 AM Subject: $$Excel-Macros$$ Word Wrap in Excel..... Dear Group, Please make haste, if u can! I want word wrap option to be active in excel – its effect should be like this. Condition 1 : the word / font train should not cross the page break line. Condition 2 : on the completion of one line the font should adjust the line previous and jump to the another cell or row to continue doing the next line. If your work fulfill this two conditions then it will be a great help to me to carry on my further work because I have lots of data to be written in excel following to the WBS (Work Break Down System) Note: See the attached file word wrap 1. ( I want to share an example also with u) Help me: please share the answered attachment in 2003 format as my system doesn’t have dual operating system. Regards, Muneer, CC….. -- 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. -- 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.
<<image001.gif>>
