> Hello, I have a one celled table that is bookmarked to a multiline textbox
> on a user form. The single cell table expands to the number of lines entered
> in the textbox when it is transferred. In some instances this returns blank
> lines, between lines of text, entered into the user form textbox, when
> transferred to the book mark.  (not sure how but probably user error) I have
> had a look at the MVP site examples, deleting empty rows & cells but I can
> not alter them to work on lines in cells, my knowledge beyond simple bits of
> code is limited. I need the code to remove these blank lines after the text
> has been transferred. I would appreciate any help offered.

> Thanks, in anticipation,
> Andrew.

> Andrew,

> Are the blank lines actually blank *pargraphs*?  (Do they show the
> paragraph mark when you click the Show/Hide button on the toolbar?)
> If so, this'll zap them:

> Dim t As Table, i As Long
> Set t = ActiveDocument.Tables(1)
> With t.Cell(1, 1).Range
>   For i = .Paragraphs.Count To 1 Step -1
>     If Len(.Paragraphs(i).Range) < 2 Then .Paragraphs(i).Range.Delete
>   Next i
> End With

> -- See the MVP FAQ at http://www.*-*-*.com/
> ----------- "Life is nothing if you're not obsessed." --John Waters
> -------------------------------------------------------------------
> Please reply only to the newsgroup.

> > Hello, I have a one celled table that is bookmarked to a multiline
textbox
> > on a user form. The single cell table expands to the number of lines
entered
> > in the textbox when it is transferred. In some instances this returns
blank
> > lines, between lines of text, entered into the user form textbox, when
> > transferred to the book mark.  (not sure how but probably user error) I
have
> > had a look at the MVP site examples, deleting empty rows & cells but I
can
> > not alter them to work on lines in cells, my knowledge beyond simple
bits of
> > code is limited. I need the code to remove these blank lines after the
text
> > has been transferred. I would appreciate any help offered.

> > Thanks, in anticipation,
> > Andrew.