PasteSpecial method of Range class Fail from one workbook to another

Hi all,

I keep getting the PasteSpecial method of Range class Fail problem ..no matter what I try

I am copying a range of cells from one workbook to another .. but upon paste it shows error.

Even though the code below says Paste:=12 .. I have tried with everything including Paste:=xlValues, xlvalues etc same message occurs

For some reason .Range("S1").PasteSpecial (xlPasteAll) works

Please Login or Register  to view this content.