Pasting over protected cells

[gkdog]

I want to paste a 30x30 table of cells over an excel sheet of which some of the cells are protected. I was hoping that excel would just paste into unprotected cells as usual and ignore protected cells.
Unfortunately this is not the case. I get an error message saying the the sheet is protected (even though only a few cells are).
So does anyone have any idea how to get round this problem?

 

[gizmo1973]

Find out which cells are protected (hoepfully it will be a row or a column) then paste over the non protected cells by row or column

Regards, Phil

"If in doubt, hit it with an end user!

 

[gkdog]

I know I can do it manually - line by line or column by column but I would like to do it in one single paste.....

 

[SkipVought]

Hi,

If this is a recurring task with the same source and destination ranges, record a macro and then run the macro.

Skip,

_{[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive!}

 

[SkipVought]

...and, I failed to recommend that the recorded macro can be improved by unprotecting, doing the copy 'n' paster and then protect.

Skip,

_{[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive!}