Macro to delete entire row if cell contains the word "total" or "Total"

**theatricalveggie** · 08-10-2011, 10:07 AM

I have a large amount of data that started as a Pivot Table. I pasted it into a new Worksheet as values only. Now I need a Macro to delete all rows that have a cell containing the word "Total." I have found a few macros online, but they are all specific to a certain columns. I need a Macro that will search the entire sheet. The cells may or may not contain other words along with Total (for example, Apples Total, Grapes Total, Pears Total).

Any help would be appreciated. Thanks!

Here are some of the strings that are somewhat relative, but I am having trouble tweaking the Macro (I keep getting Run Errors):
http://www.excelforum.com/excel-prog...-contains.html
http://www.ozgrid.com/forum/showthre...t=84092&page=1

**Andrew-R** · 08-10-2011, 10:18 AM

You could try this:

Please Login or Register  to view this content.

**BigBas** · 08-10-2011, 10:22 AM

Try:

Please Login or Register  to view this content.

**theatricalveggie** · 08-10-2011, 10:23 AM

Andrew - It worked perfectly!!! Thank you so much!

**JBeaucaire** · 08-10-2011, 12:38 PM

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

Macro to delete entire row if cell contains the word "total" or "Total"

LinkBack

Thread Tools

Rate This Thread

Display

Macro to delete entire row if cell contains the word "total" or "Total"

Re: Macro to delete entire row if cell contains the word "total" or "Total"

Re: Macro to delete entire row if cell contains the word "total" or "Total"

Re: Macro to delete entire row if cell contains the word "total" or "Total"

Re: Macro to delete entire row if cell contains the word "total" or "Total"

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions