![]() |
#6
|
||||
|
||||
![]()
Try the following. It works with a range of selected cells.
Code:
Sub CellXfer() Application.ScreenUpdating = False Dim i As Long, RngTbl As Range, RngCell As Range Set RngTbl = Selection.Range On Error Resume Next With RngTbl If .Information(wdWithInTable) = True Then For i = 1 To .Cells.Count Step 2 If .Cells(i).Row.Index = .Cells(i + 1).Row.Index Then Set RngCell = .Cells(i + 1).Range With RngCell .End = .End - 1 .Cut End With Set RngCell = .Cells(i).Range With RngCell .End = .End - 1 If Len(.Text) = 0 Then .Paste ElseIf .Characters.Last = vbCr Then .Collapse wdCollapseEnd .Paste Else .Characters.Last.InsertAfter vbCr .Collapse wdCollapseEnd .Paste End If End With End If Next End If End With Application.ScreenUpdating = True End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
merge, table |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Jag618 | Mail Merge | 1 | 03-04-2013 11:26 PM |
Cannot Merge Into A Table | MacDee | Mail Merge | 1 | 01-29-2013 07:21 PM |
![]() |
nadja | Mail Merge | 5 | 03-06-2012 05:41 PM |
![]() |
donbexcel | Word VBA | 2 | 10-21-2011 11:46 AM |
![]() |
RBusiness | Word | 1 | 06-07-2011 04:26 PM |