Frank News wrote...
....
>I am trying to update a protected sheet automatically from a second sheet
>and only the 2 columns I am supposed to enter data into are unprotected (can
>be changed). I have the whole thing working now with a macro except for the
>cells which are supposed to remain empty. If I use "" then it messes up a
>subsequent formula, and if I use 0 then it looks wrong (I want to place the
>value in each cell of the column only if it meets a certain condition, else
>leave it empty.
>
>Is there a way to make a cell empty as opposed to just looking empty?
>I tried to replace all 0 with <delete key> but that didn't work ...

If you're using macros to fill these cells, you have two alternatives.

cellref.Value = Empty
cellref.ClearContents

Both work just fine on unlocked cells in protected worksheets.