Have you tried recording a macro to do this? The paste you want is "pasteSpecial" from the edit menu instead of hitting the paste icon.