Copying text range of cells to different cells adds an extra line

		Microsoft Office Forums > Microsoft Word > Word VBA
Copying text range of cells to different cells adds an extra line

07-23-2014, 10:16 AM

jpb103

Windows 7 64bit Copying text range of cells to different cells adds an extra line

Office 2007

Advanced Beginner

Join Date: May 2014

Location: Thunder Bay, Ontario

Posts: 58

Copying text range of cells to different cells adds an extra line

Hey Fellas,

I've got a macro that moves the text from one cell to another. The code goes something like this:

Code:

Dim oRow as Row
set oRow = ActiveDocument.Tables(2).Rows.Add
oRow.Cells(1).Range.Text = ActiveDocument.Tables(1).Rows(1).Range.Cells(1).Text

The problem I'm having is that when the text is copied over to the new cell, it adds an extra line on the end. Any thoughts, Word VBA community?

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Color-fill a range of cells, based on text in a different sheet. Possible?	unittwentyfive	Excel	2	06-01-2014 06:48 AM
Copying a formula that uses pivottable cells	Paul46	Excel	0	02-08-2014 07:04 AM
Copying cells	isminoh	Excel	5	04-18-2012 11:49 AM
Set range for merged Word table cells?	tinfanide	Word VBA	1	02-06-2012 05:57 AM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:43 AM.