Hi
try
If InStr(cell.value,code) then...

--
Regards
Frank Kabel
Frankfurt, Germany

Hi, thank you ! I also needed this one. But can you pls explain
further - what if I want:

IF (code) is (part of cell content)
THEN (move to column AJ)

The macro you pasted above works only if it is a full match. Thank
you.


---
Message posted from http://www.ExcelForum.com/