Prev: Positioning Text on a Page (Word 2007 VBA)
Next: Remove Macros from Template
From: FHSchmid on 25 Apr 2010 22:55
I want to copy the text in a cell where the cursor is to another document. I
know how to copy to the other document. I do not know how to select all the
text in the cell where my cursor is.
Thanks for your help.
Fred
From: Doug Robbins - Word MVP on 25 Apr 2010 23:18
Dim rng as Range
Set rng=Selection.Cells(1).Range
rng.End = rng.End - 1 'strips off the end of cell marker

rng will now contain the text from the cell.

There may be no need to use copy. In the other document, you can just use
rng.Text

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"FHSchmid" <FHSchmid(a)discussions.microsoft.com> wrote in message
news:CC676D75-5D73-4CB5-BCF7-9A33872C33D1(a)microsoft.com...
> I want to copy the text in a cell where the cursor is to another document.
> I
> know how to copy to the other document. I do not know how to select all
> the
> text in the cell where my cursor is.
> Thanks for your help.
> Fred

 | 
Pages: 1
Prev: Positioning Text on a Page (Word 2007 VBA)
Next: Remove Macros from Template