Forum Discussion
Discrepancy between function Argument and cell display
I have two sheets in a workbook. One is protected accept about two dozen cells. The other is not protected. When I run a macro to copy and paste 19 cells from the unprotected sheet to 19 cells ...
The Locked property is part of the cell formatting, so if you do a plain copy and paste, the target cells receive all formatting of the source cells. Try doing a paste special formulas (or values, depending on your needs) instead.
Thank you sooo much! Special paste works!