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?
Bookmarks