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.

 

Ur example 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.


<<image001.gif>>

Reply via email to