Jim,
I appreciate your reply, however the clipboard is not being clearerd. When I
switch to the destination workbook I can paste from the clipboard but I
cannot by right-clicking the mouse, using the edit menu, or control keys.
Therefore I cannot perofrm a paste special.