Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 11-04-2021, 07:56 AM
JingleBelle JingleBelle is offline Delete First and Last Rows If.... Windows 10 Delete First and Last Rows If.... Office 2016
Novice
Delete First and Last Rows If....
 
Join Date: Nov 2020
Posts: 26
JingleBelle is on a distinguished road
Default

Hey, Andrew.


Thank you for adjusting the code for me. There is NO way I would have come up with that on my own.


It works like charm, and I appreciate the tip about the search term being in the first and second row. Of course, that had not occurred to me. I don't think that will be an issue.


The macro works as I wanted; however, it did fail when it encountered a table with a vertically merged cell. I had not considered that obstacle either. I think, though, in my notes somewhere or in some code I picked up on this forum, there is a way to avoid or skip over those tables. With any luck, I will be able to cobble the two together and get it to work. Having said that, I may be back.


Thank you, again, for your willingness to help me. I appreciate it very much.
Reply With Quote
 

Tags
delete table rows, first row last row, specified text string



Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete First and Last Rows If.... Delete blank table rows in merged document and split document in docx and pdf based on excel rows Alex1s85 Word VBA 5 05-22-2021 12:05 PM
Delete First and Last Rows If.... Delete blank rows between the two rows that contain data beginner Excel Programming 5 12-26-2014 12:29 AM
Delete First and Last Rows If.... Delete All empty Rows - Print - Undo all Rows deleted Bathroth Word VBA 1 10-01-2014 01:40 PM
Find and Delete Rows damaniam Word VBA 1 03-11-2014 06:54 AM
Delete First and Last Rows If.... Delete all rows but the last. elky1967 Word VBA 14 09-21-2012 05:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:08 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