How to delete entire row if text string from first column match text string from text file

Hello
I have a text file called del.log
del.log sample:
STRING1
STRING2
STRING3

Also I have excel sheet with almost 1 000 000 rows in it. I'm looking for a EFFECTIVE way how to delete entire row if text string in column A exactly matches one of text strings from del.log file?

Thank you for any suggestions.

This should work in 2010.
It does not work in 2007 because of the 8192 limit for SpecialCells.

Please Login or Register  to view this content.

Greetings from Sherwood Park

Thank you for your help. It works however I need somehow read those strings from external file del.log and delete rows based on strings saved in del.log file.