using Criteria with two possible values
 

okay, you lost me... I dont know where in my code to put that code yo
just posted. Just to reiterate, I want to delete all rows that hav
the words "not in system" in column J, and all rows that have "NOT OKC
in column j

--
DK
-----------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...fo&userid=1451
View this thread: http://www.excelforum.com/showthread.php?threadid=27563