Macro to Unprotect Sheet, Paste then Protect Sheet

It would basically look like this:

Please Login or Register  to view this content.

Replace capitalised parameters to suit.

You don't need to do all that selecting, that's just slowing stuff down.

@ Olly,

Hello Olly,

I like your reply, although your Code assumes Named Ranges, which I am not so sure the OP may have.

Regards.

The OP's source and target ranges weren't clear - so I tried to show some GENERIC code, and make clear that the capitalised bits need replaced with specific sheet names / range addresses

Of course, named ranges would work beautifully, but replacing Range("SOURCERANGE") with Range("A3:Y3") would work equally well.

Thanks for clarifying!

@ Olly,

Thank you for not taking any offence to my comment!

With your reply, you have actually clarified everthing, thank you.

@ tokyojo1,

Olly has provided you with a very good solution, which you seem to be satisfied with.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, since you are relatively new to the forum, I would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which you have been helped. This adds to the reputation of the person who has taken the time to help you.

Thanks.