The line

If Not IsError(Application.Match(Range("A" & i).Value, myList)) Then

should be

If Not IsError(Application.Match(Range("A" & i).Value, myList, False)) Then

Sorry about that.

HTH,
Bernie
MS Excel MVP


"username" wrote in message
...

It seems that your code works a little too well!

I have specified the items in the myList array accurately, but the
'match' test seems to be a little loose in its application. Any text in
the column beneath my Audiences (even with no relation to the text
specified in the myList array) also seems to bring up a match and thus
its row gets deleted.

Is there a way to force an 'exact match'?

Many thanks again


--
username
------------------------------------------------------------------------
username's Profile: http://www.msusenet.com/member.php?userid=1433
View this thread: http://www.msusenet.com/t-1870445735