LinkBack URL
About LinkBacks
I am wondering if there is a macro that can find the the cells that contain the word "time" and delete that entire row, and find the word "name and delete the entire row. Any Help would be greatly appreciated Thanks.
I am wondering if there is a macro that can find the the cells that contain the word "time" and delete that entire row, and find the word "name and delete the entire row. Any Help would be greatly appreciated Thanks.
Try this, it loops through the UsedRange to find cells containing the specified words. Then creates a range by using the Union method. Finally it deletes the rows within that range.
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
This example will populate the listbox with unique values from Column W and delete rows that match your criteria when you select in the ListBox.
Click on a cell in Column D hat contains GENERAL LEDGER" to display the form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks