Hi,

I got a new computer with office 64 bit. Same copy and paste code work in 32 bit but not in 64 bit.

32 bit

   Range("B2").Copy
        ActiveSheet.Range("H6").PasteSpecial Paste:=xlValues
        ActiveSheet.Range("AB6").PasteSpecial Paste:=xlValues
        ActiveSheet.Range("AG6").PasteSpecial Paste:=xlValues
        ActiveSheet.Range("AF6").PasteSpecial Paste:=xlValues
I have to add Copy before each paste so those paste can work in 64 bit

   Range("B2").Copy
        ActiveSheet.Range("H6").PasteSpecial Paste:=xlValues
    Range("B2").Copy
        ActiveSheet.Range("AB6").PasteSpecial Paste:=xlValues
    Range("B2").Copy
        ActiveSheet.Range("AG6").PasteSpecial Paste:=xlValues
    Range("A2").Copy
        ActiveSheet.Range("AF6").PasteSpecial Paste:=xlValue
s

Anyone know why?