Hi all,

There have been similar answers to my solution but this is a little more specific.

I copy and paste to an 'archive' sheet sales of the day. I want to automatically lock the cells. Rather than lock just the cells that are non blank, i want to lock the whole line.
When i copy, column A which is a date value is always non blank but the cells underneath the last pasted line are always blank.

So to summarize i paste and lock the whole row(s) of those pasted cells. Can anyone please help?

Thanks as usual,

Chris