copy and paste issue after upgrading to office 64 bit

[pmchris]

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

Please Login or Register  to view this content.

I have to add Copy before each paste so those paste can work in 64 bit

Please Login or Register  to view this content.

s

Anyone know why?

[beyond Excel]

Hello! I start by saying that the Office change has nothing to do with your problem.
And I ask you: Is it possible that this sheet has an event encoded as Change?

[pmchris]

This sheet doesn't have any encoded event. It is just simple code. Same issue happened on my other macros. I think probably I need to change some excel setting in 64 bit, but no idea how?

[Marc L]

Hi,

according to Excel basics you should better use whatever the Excel version this codeline obviously : [H6,AB6,AF6,AG6] = [B2] ...

[beyond Excel]

Look, it is possible to give you alternatives to the macro you use like:

'Option 1: 
Range("B2").Copy 
Range("H6, AB6, AG6, AF6").PasteSpecial Paste:=xlValues 
 
'Option 2: 
Range("H6,AB6,AG6,AF6") = Range("B2").Value  

However, we are not getting to the bottom of the problem, which is to find the source of the error that - I insist - changing the version of Excel has no effect on your code: you would have to upload your workbook to the Forum to see it...

[pmchris]

Thanks anyway.