Remove Rows With Specific Phrase Using Another Worksheet

So I needed a Macro that would remove any row with a phrase or word detected. This is what I have and it works perfectly:

Please Login or Register  to view this content.

The problem is that I have over 1,000 entries that I need to put into the array for removal.

Arrays, Dictionary, Etc all have limits and there are only so many line continuations allowed in the viewer.
I was looking to just call from column 1 of sheet2 to get my list, but am having problems with the code:

Please Login or Register  to view this content.

Can someone please help fix this code and help me understand why this is so difficult?

IT WORKS PERFECT... BUT

For some reason it is giving an error when parsing too much data? Please take a look.

The easiest way is to attach the excel file so you can see the macro and sheet I have.
It might not be your code, but perhaps the data in Sheet2.

The only problem is that the entries need to stay exactly the same.
Case, Punctuation, Spacing, Spelling.

Here is my file

SC FILTER.xlsm

http://www38.zippyshare.com/v/74954447/file.html

Try this

Please Login or Register  to view this content.

or so

Please Login or Register  to view this content.

Jubilee 1500 posts

Both of those codes work, but when I add more, I still get errors. Would it be because of the punctuation and special characters that causes the problems? There are some entries that have CAFÉ