Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-11-2024, 03:40 AM
George24 George24 is offline Refer to second table in document Windows 11 Refer to second table in document Office 2021
Novice
Refer to second table in document
 
Join Date: Jan 2024
Posts: 6
George24 is on a distinguished road
Default Refer to second table in document

Hi,


I have a Word document with 2 tables. The macro I want to run should only apply to the second table. How do I do this? Please explain like I'm 5?

Sub DeleteEmptyRows()
Dim tbl As Table, cel As Cell
Dim i As Long, j As Long, n As Long, fEmpty As Boolean
Application.ScreenUpdating = False
With ActiveDocument
For Each tbl In .Tables
n = tbl.Rows.Count
For i = n To 1 Step -1
fEmpty = True
For j = 3 To tbl.Rows(i).Cells.Count
Set cel = tbl.Rows(i).Cells(j)
If Len(cel.Range.Text) > 2 Then
fEmpty = False
Exit For
End If
Next j
If fEmpty = True Then tbl.Rows(i).Delete
Next i
Next tbl
End With


Set cel = Nothing: Set tbl = Nothing
Application.ScreenUpdating = True
End Sub
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Refer to second table in document Index hyperlinks refer to old version of document Perkzzz Word 7 11-13-2016 06:54 PM
Refer to second table in document Change Macro so it does not refer to "Active Document" trent.bourne Word VBA 2 10-30-2016 01:49 AM
Refer to second table in document Trying to refer to a placeholder several times throughout a document caitlin Word VBA 2 11-16-2015 04:29 AM
Refer to second table in document Excel table: refer to a particular row? tinfanide Excel 10 08-05-2015 01:17 PM
How do I refer to page numbers, when the numbers change as I prepare the document? StevenD Word 5 11-29-2012 12:52 AM

Other Forums: Access Forums

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


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft