If you don't past formats, you won't change the destination format.

What do you really want to know?



--
Regards,
Tom Ogilvy

Bill Oertell wrote in message
...
Is there any way to preserve the destination formatting whenever a user
copies and pastes from another workbook?