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.
I have never seen something like this, any help would be appreciated.Please Login or Register to view this content.
Bookmarks