Thread: [Solved] Macro to split table cells
View Single Post
 
Old 03-07-2016, 10:20 PM
nachiketapte nachiketapte is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Mar 2016
Posts: 5
nachiketapte is on a distinguished road
Default Macro to split table cells

I have the below requirement. I have a input similar to this


#


Drawings


Drawing Type


1


Drawing 4, Drawing 27


EC, C



Now I would like to have the output similar to this


#


Drawings


Drawing Type


1


Drawing 4


EC


2


Drawing 27


C



Can some expert help me with this

I found the following piece of code written on one of the forum and thought would be of help to me.
Code:
Sub TableSplitter()
Application.ScreenUpdating = False
Dim Tbl As Table, RngFnd As Range, StrFindTxt As String
StrFindTxt = InputBox(",")
If Trim(StrFindTxt) = "" Then Exit Sub
For Each Tbl In ActiveDocument.Tables
  Set RngFnd = Tbl.Range
  With RngFnd.Find
    .ClearFormatting
    .Text = StrFindTxt
    .Replacement.Text = ""
    .Forward = True
    .Wrap = wdFindStop
    .Format = False
    .MatchCase = False
    .MatchWholeWord = False
    .MatchWildcards = False
    .MatchSoundsLike = False
    .MatchAllWordForms = False
    Do While .Execute
      With RngFnd.Duplicate
        'The next two lines break the table *after* the found row
        If .Cells(1).RowIndex < .Tables(1).Rows.Count Then
          .Tables(1).Split .Cells(1).RowIndex + 1
        End If
        'The next two lines break the table *before* the found row
        If .Cells(1).RowIndex > 1 Then
          .Tables(1).Split .Cells(1).RowIndex
        End If
        .Collapse (wdCollapseEnd)
      End With
    Loop
  End With
Next
Set RngFnd = Nothing
Application.ScreenUpdating = True
End Sub

Last edited by macropod; 03-07-2016 at 10:31 PM. Reason: Added code tags & formatting
Reply With Quote