"Delete the visible rows".

To select visible rows hit F5SpecialVisible rows only

EditDelete will delete all at once.


Gord Dibben MS Excel MVP

On Sat, 31 May 2008 10:16:22 -0700 (PDT), wrote:

On May 31, 11:34*am, Dave Peterson wrote:
I would add a header row, then do data|filter|autofilter on that column.

Use the dropdown arrow
Contains
beta

And then delete the visible rows

Then remove the autofilter.





wrote:

Is there a macro whereby if I have a list, all in one column, but
different rows:

Column A:

Row 1: Alpha Beta Gamma
Row 2: Alpha Alpha Alpha
Row 3: Beta Gamma Gamma
Row 4: Gamma Gamma Alpha

If I wanted to delete all rows in MS Excel that have the word "Beta"
in it, I should be left with:

Alpha Alpha Alpha
Gamma Gamma Alpha

Thanks.

--

Dave Peterson- Hide quoted text -

- Show quoted text -

Dave,

Thanks, that sounds like a good idea, especially for a short list.
But my lists are always more than a thousand rows, and, unless I'm
missing a step here, it would take a very long time to delete all
those rows manually, that's why I was trying to find an automated
system.