Hi,

Can you do this and does someone have code for it? I need to restore formats
on a sheet and found that running a lot of "format restore procedures" on
worksheet events has some major drawbacks (other threads) and look for other
solutions. I run the routines on worksheet_change but I guess I need to
cover drag and drop frm othet workbooks as well someway, but that's another
question.

Another way could be some kind of routine to check target cells and look in
an other "Mirrorsheet" with correct formats and recover formats from there -
not using something to kill the clipboard content. Since users can change
nearly everything in a cell, there had to be routines for nearly every cell
format variable, so it had to be compatible to like the scope of
"pastespecial format", iwthout killing th clipboard ....

/Kind regards