Copy ignores certain columns.

Well this is the first time in many years that I am stuck.
I am opening a file from one workbook and copying data from that workbook to the one with the macro running in it.
So the problem is it ignores the last column data and copies the data in the next column.
Eg, it copies the data fine until column "AI", but ignores column "AJ3:AJ64" , but show the data from "AK3:AK64". The column is not hidden and has the same formatting as all the other columns.

I tried all the the usual methods below to no avail. I even ran a loop copying each individual cell with no luck. I ran some code to make sure the columns were visible and still nothing.

Please Login or Register  to view this content.

I have never seen something like this, any help would be appreciated.

Not sure whether I can able to fix the issue. But just wanted to give a try...

I just tried your code with a sample workbook and it seems to be working fine.

I believe you have to attach the error file for testing purpose

The code is sound, which is why I am stumped. I really did not want to have to post the workbooks as they are a pain to get all the personal data out of them. But if no-one has any ideas, I will post them up.

Dave

Just to check - you don't have hidden columns in the destination worksheet either?

I am creating a new sheet each time I transfer the data and from debugging there seems to be nothing like that happening.

But even trying to get any data from a single cell in that particular column also has it pick up the data next to that cell in the next column. This is really weird.

I think we'll need the workbook then.

Maybe:

Please Login or Register  to view this content.