Having an issue deleting rows based on certain text found in them...

Hey Guys,

I'm having a little issue deleting entire rows when certain text is found in them, basically if there are two rows next to one another it only deletes one of the offending rows because the second row becomes the first row, I know how to fix it but am unsure how to code it.

My current code is as follows:

Please Login or Register  to view this content.

It should be going from bottom to top to avoid this or putting them in a group and then deleting them all at once, could someone help me with this problem.

Thanks in advance
- Hyflex

Hi Richard,

For some reason filters seem to act up on my computers as I switch between 2003, 2007, 2010 and 2013 (different computers have different versions installed), I avoid filters at all costs because of this.

Is there an easy alternative?

Thanks
- Hyflex

Hey Richard,

Well yeah, I agree they are slow but my data is only 5,000 rows so it's pretty much nothing so it wouldn't be a problem.

The issue is it crashes excel, debugs and sometimes just doesnt do anything.

I had a go at doing it via autofilter and ran into a problem where if there are no rows it errors out as it can't find anything...

Please Login or Register  to view this content.

Note: Column 1 and 3 have data in them which I don't want touched so I changed it to A4 instead of A1

Originally Posted by Hyflex

I had a go at doing it via autofilter and ran into a problem where if there are no rows it errors out as it can't find anything...

Please Login or Register  to view this content.

Note: Column 1 and 3 have data in them which I don't want touched so I changed it to A4 instead of A1

I can't seem to work out how to detect if it's caught any results.

I did a backwards step loop as seen below:

Please Login or Register  to view this content.

Rand was just an easy and quick way of generating a large sample set.

Can get large sample sets other ways.

Point being made was that general statements such as "... looping macros ... are inherently slow and less efficient." (as compared with filters) are in many cases just not correct, and thus may be unhelpful to contributors seeking help.

Following code was used to generate, as illustrative counter-example, a large set of numbers

Please Login or Register  to view this content.

If aim is to find the unique values from the resulting dataset, like Excel's RemoveDuplicates tries to do, then filtering is inherently slow and inefficient.