Clear cell if equals certain value

[clwrs]

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.

[shua79]

For N/A I would use the following

Please Login or Register  to view this content.

for the other two its basically the same

Please Login or Register  to view this content.

Hope this helps

[JBeaucaire]

Another approach that does more than one row at a time:

Please Login or Register  to view this content.