I've protected a column of cells in my worksheet, but I've also set it so
that rows can be added and deleted.

But if I try to insert a row and copy the data from an existing row, I get
an error since I'm trying to 'update' the protected cell.

A similar problem happens when I try to delete (I'm assuming because one of
cells is protected and it thinks I'm trying to change it.)

What's the purpose of allowing adding and deleting rows to protected sheets
if it doesn't work when a row has a locked column.? bIs there any way around
this?

Thanks