Filter and Delete

[puuts]

Hello,

I just want to filter Column E that is not starting with "ARROW".
and delete the filtered data, so starting with "ARROW" data will be left.

I have attached my file.

Thanks in advance Gurus!

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Kaper]

Hi John, shall it be really xlPart?

Anyway, mine is almost the same

Please Login or Register  to view this content.

[JOHN H. DAVIS]

@ Kaper - I didn't test it. But it seems that it doesn't require it. Works either way. Yours works as well.