Thanks xld,

It works perfectly. Instead of trying to learn VBA I should learn Excel functions first. I never used NOT before ever.