Macro to KEEP only the rows containing certain text, delete the rest.

[linda88]

Im looking for a macro/code to KEEP only the rows containing certain text, and delete the remaining rows. This is a little tricky because for example I want to keep rows containing "xxxx" and to keep rows containing "yyyy", and "zzzz", then delete or clear all remaining rows.
The tricky part is that once the code find the rows containing "xxxx" it cannot immediately delete ALL other rows because some of those rows may contain "yyyy" or "zzzz".

 

[Peter_SSs]

I meant excel 2003

Yes, that does explain it. XL2BB is only designed to work with Excel 2007 and later & won't be altered to try to work with versions older than that, sorry. You are using a very old version!

Another option is to simply copy and paste from Excel and describe what you have posted. Example, this is the range D1:E10

54677	a
yjthsacv	b
yyyy	c
77678	d
67756223	e
xxxx	f
76456	g
897809	h
zzzz	i
gtrfryhrg	j

 

[linda88]

I tried this but it actually deletes everything. All the rows.

Actually it does work.. Thank you!