![]() |
|
#1
|
|||
|
|||
![]() Hello, could you help me tweek this current vba to include content controls? It will delete the empty rows but it wont delete with empty content controls. Hope that makes sense. Thank you! |
#2
|
||||
|
||||
![]()
Try:
Code:
Private Sub CommandButton1_Click() Application.ScreenUpdating = False Dim Tbl As Table, cel As Cell, r As Long, x As Long Dim bDel As Boolean, CCtrl As ContentControl With ActiveDocument For Each Tbl In .Tables For r = Tbl.Rows.Count To 1 Step -1 With Tbl.Rows(r) If Len(.Range.Text) = .Cells.Count * 2 + 2 Then .Delete Else bDel = True For Each cel In .Cells If Len(cel.Range.Text) > 2 Then If .Range.ContentControls.Count = 0 Then bDel = False: Exit For Else For Each CCtrl In .Range.ContentControls If CCtrl.ShowingPlaceholderText = False Then bDel = False: Exit For End If x = x + Len(CCtrl.Range.Text) Next If x + 2 <= Len(cel.Range.Text) Then bDel = False: Exit For End If End If End If Next cel If bDel = True Then Tbl.Rows(r).Delete End If End With Next r Next Tbl End With Set cel = Nothing: Set Tbl = Nothing Application.ScreenUpdating = True End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
![]()
Thank you so much!
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
sylvio | Word VBA | 9 | 08-30-2017 01:46 AM |
![]() |
kevinbradley57 | Word VBA | 10 | 08-17-2017 02:13 PM |
Macro to save docx to doc that checks compatibility and converts content controls to static content. | staicumihai | Word VBA | 4 | 10-12-2016 08:23 PM |
![]() |
Bathroth | Word VBA | 1 | 10-01-2014 01:40 PM |
Content Controls - Add Table Rows | dgiromini | Word VBA | 1 | 04-11-2014 03:04 PM |