![]() |
|
![]() |
|
Thread Tools | Display Modes |
|
#1
|
||||
|
||||
![]() Try this code Code:
Sub TableSplitter() Dim aTbl As Table, i As Integer, sVal As String, sValPrev As String Set aTbl = Selection.Tables(1) For i = aTbl.Rows.Count To 3 Step -1 On Error Resume Next sVal = Split(aTbl.Rows(i).Cells(1).Range.Text, ".")(1) sValPrev = Split(aTbl.Rows(i - 1).Cells(1).Range.Text, ".")(1) On Error GoTo 0 Debug.Print "Row:" & i, sVal, sValPrev If sVal = sValPrev Then GoTo Jumper Else aTbl.Split i End If Jumper: Next i End Sub
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
epid011 | Word Tables | 2 | 05-15-2017 05:21 PM |
![]() |
Dudlee | Word VBA | 1 | 09-20-2016 04:58 PM |
![]() |
jc491 | Word VBA | 8 | 09-30-2015 06:10 AM |
![]() |
RobsterCraw | Word VBA | 16 | 11-20-2012 03:25 PM |
![]() |
tinfanide | Word VBA | 3 | 04-27-2012 09:48 AM |