Delete entire rows if cells include "Paper".

Hi friends,
Open an excel file,
Make sure your excel file includes a sheet named "Sheet1",
Type "Title1" into A1 cell,
Type "Title2" into B1 cell,
Type "Title3" into C1 cell,

Type "friend" into A2 cell,
Type "friend" into B2 cell,
Type "friend" into C2 cell,

Type "friend" into A3 cell,
Type "Paper" into B3 cell,
Type "friend" into C3 cell,

Type "friend" into A4 cell,
Type "friend" into B4 cell,
Type "friend" into C4 cell,

Run following code to see how code delete entire rows if cells include "Paper"...

Please Login or Register  to view this content.

The code above is very good working but lets go further...
Because I dont want to use autofilter...

In the following video's way is better than my way that I explained above...
I need your support regarding changing following video's issue to the macro code.
http://www.youtube.com/watch?v=6-dGDsKyEQ0

Thanks in advance.