I am trying to learn how I can program into a macro the function of clearing, and not deleting, a cell in column k, n and o if it is equal to a cerain value. These values would be #N/A, 1/0/1900 and 0 respectively. Thank you for your help.