Click to See Complete Forum and Search --> : end-of-row mark Microsoft Word
shragel
Dec 22nd, 2005, 08:14 AM
How can i search for the end-of-row mark in word find?
What the special format.
RhinoBull
Dec 22nd, 2005, 08:35 AM
Isn't it a (CARRIAGE RETURN + LINE FEED) - basically vbNewLine for each new line and (LINE FEED) for each line that's wrapped ?
shragel
Dec 22nd, 2005, 08:36 AM
I am talking in the microsoft find. like /p means paragraph mark and /t = tab mark. What finds the end of row mark?
RhinoBull
Dec 22nd, 2005, 08:38 AM
I am talking in the microsoft find. ...
What's that ??? :confused: What are you trying to do anyway?
Hack
Dec 22nd, 2005, 09:07 AM
What's that ??? :confused: What are you trying to do anyway?I think he is talking about doing this from within Word itself using VBA which is why we were a little confused.
Moved to Office Development.
shragel
Dec 22nd, 2005, 05:33 PM
So does anyone know the answer?
RobDog888
Dec 22nd, 2005, 05:42 PM
If your taking about paragraphs line wrapping and being able to determine the word that is at the end of the line before it wraps then I do not believe there is a character for that. Its all about what fits on the line as Word will start the rest of the sentence/paragraph on the next line. You may be able to determine the number of lines or get the verbiage on a line.
shragel
Dec 22nd, 2005, 05:48 PM
I am talking in a table where is such a mark for the end of the cell, or end of the mark. I am looking to search for that.
Like shown in this link
http://www.oreilly.com/catalog/word2000ian/chapter/ch10.html
RobDog888
Dec 22nd, 2005, 06:00 PM
Oh, then you want the .Clees in a .Row. If you set an object variable to the table and then another one to the particular row in question then you will get the needed object property.
shragel
Dec 22nd, 2005, 06:06 PM
My problem is that when i am creating a mail merge for labels, all the labels get a extra paragrah before the end, so what i want is to delete the last paragraph from all labels so that it showld be centered.
RobDog888
Dec 22nd, 2005, 10:33 PM
So then in the paragraph in each cell you will want to remove the "^p" from it. ^p is Words paragraph or new line character. ;)
shragel
Dec 22nd, 2005, 10:53 PM
but i only want to remove the last one of each cell
For example
Name {Enter}
Address {Enter}
City, State Zip {Enter}
{Enter}
{End of cell mark}
And i need to remove only the last enter from each cell.
RobDog888
Dec 22nd, 2005, 10:55 PM
You can use Instr or InstrRev to find the last occurance of the ^p character. Or youcan use the Replace function and specify the last character of the string as the starting point.
dglienna
Dec 22nd, 2005, 10:59 PM
Oh, then you want the .Clees in a .Row. If you set an object variable to the table and then another one to the particular row in question then you will get the needed object property.
All I can say, is "Merry Christmas to all, and to all, a good night"
shragel
Dec 22nd, 2005, 11:12 PM
but i need to remove the lasst of each cell.
See the attached document.
RobDog888
Dec 22nd, 2005, 11:37 PM
Dont know what dglienna is talking about but anyways...
You can loop through the cells in a row and replace the ending paragraph character with a empty string.
Dim cel As Cell
For Each cel In ActiveDocument.Tables(1).Rows
cel.Range.Text = Replace(cel.Range.Text, "^p", vbNullString, Len(cel.Range.Text) - 2, , vbTextCompare)
Next
dglienna
Dec 22nd, 2005, 11:41 PM
Oh. Now I understand. .Clees = .Cells
My mistake. :)
RobDog888
Dec 22nd, 2005, 11:43 PM
:D I didnt even see that. I am a bit dyslexic. Doubled up on the e's instead of the l's.
vbforums.com
Copyright Internet.com Inc., All Rights Reserved.