I'm not understanding you. Do you want it to search on Column C only? Then msgbox if empy cell found? Or Columns (A,B,D,F) also?