<div>
That is simply great, thank you.<br />
<br />
One last question: How can I have rngFind.Find.Execute() search for either &quot;Application Domain&quot; OR &quot;Subdomain&quot;. In my table, an Application Domain can have 1 or more Subdomains.<br />
<br />
The order it finds the rows is important, as I want to modify this code to copy the Description row together with the current Domain row to a different file.<br />
<br />
Thanks a bunch, this was lovely.<br />
<br />

</div>


That is simply great, thank you.

One last question: How can I have rngFind.Find.Execute() search for either "Application Domain" OR "Subdomain". In my table, an Application Domain can have 1 or more Subdomains.

The order it finds the rows is important, as I want to modify this code to copy the Description row together with the current Domain row to a different file.

Thanks a bunch, this was lovely.



<div>
<div class="content wysiwyg-content">
Hello all,<br />
<br />
How can I pinpoint the location of a Cell within a Table, and delete the row underneath it? I have vertically merged cells, and apparently the Rows collection fails.<br />
<br />
The Cell contains a keyoword such as: &quot;Application Domain &quot;&nbsp;or &quot;Subdomain &quot;&nbsp;and I want to delete the row under the cells which contain any of these strings.<br />
<br />
Should I look into a Macro that uses the Search Function, or somehow run through each cell of the Table?<br />
<br />
What is a clever way of dealing with this?<br />
<br />
<br />
Thank you very much,<br />

</div>
</div>


Hello all,

How can I pinpoint the location of a Cell within a Table, and delete the row underneath it? I have vertically merged cells, and apparently the Rows collection fails.

The Cell contains a keyoword such as: "Application Domain " or "Subdomain " and I want to delete the row under the cells which contain any of these strings.

Should I look into a Macro that uses the Search Function, or somehow run through each cell of the Table?

What is a clever way of dealing with this?


Thank you very much,


VBA Word ¦ Search for contents in Table Cells and delete adjacent row.

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Microsoft Word is a commercial document editing program that is part of the Microsoft Office suite. It features numerous text-editing tools for creating richly formatted documents, along with tools for the use of macros in Word documents. Word's native file formats are denoted either by a .doc or .docx file extension. Plugins permitting the Windows versions of Word to read and write formats it does not natively support, such as the OpenDocument format (ODF) are available. Word can import and display images in common bitmap formats such as JPG and GIF. It can also be used to create and display simple line-art.

Microsoft Word

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.