Pastespecial method of range class failed error

[laali]

Hi

I get the error when trying to run a wrkbook on my machine 'Pastespecial method of range class failed' error.

Fails on the code below:

'Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False'

I've double checked the i have both the source file and destination file, checked that they are not protected. The code works find on a different machine both have the same version of excel installed on there aswell.

See full code for sub below:

Please Login or Register  to view this content.

Any ideas?

[Domski]

You've got a lot of unnecessary activating and selecting going on but don't think that would cause it not to work on a specific machine:

Please Login or Register  to view this content.

Dom