Use other workbook to act as a 'stop-list'

Hi all,

Sorry - not a very good title.

I have a macro where I have hardcoded which rows are deleted based on the below code. However this list may need to be updated quite frequently. Is there anyway - so that I can have others update it themselves – I can have a link to an external worksheet, where say, whatever is in column A of that worksheet would act as a stoplist.

So for example if on this 'stop-list' I have the words 'please', 'delete' and 'me' in cells A1, A2 and A3 then these rows would be deleted. I think I would need up to about 50 words (i.e. A1:A50).

Is this workable?

On Error Resume Next
With Range("A1:A" & ActiveSheet.UsedRange.Rows.count)
    .Replace "*please*", "True", MatchCase:=False
    .Replace "*delete*", "True", MatchCase:=False
    .Replace "*me*", "True", MatchCase:=False
    .Columns(1).SpecialCells(2, 4).EntireRow.Delete
End With