Can't Bypass error Copy area and CopyPaste are not the same

MainFile.xlsmDataSource.xls

Hi guys,

I wrote code to copy data from one workbook that is closed and I need to paste it on the next available blank row in the workbook I am working in called "dashboard Shell1", but I keep getting the error message "The information cannot be pasted because the copy area and the copy paste area are not the same size" This is because the sheet I am working on where the data will be pasted is using merged cells (need to stay merge) [view image]
002- DASHBOARD.PNG


the data come from one Column in this sheet...
002- DATASHEET.PNG

here's the code I used, the error I mention comes in at the pasting part

Please Login or Register  to view this content.

Please help someone!! Please

From the picture, none of those merged cells is necessary unless there is something to the far right side that you did not show us. You adjust the row height/width by using the cell format menu or just drag the row header separator bar on the left down as desired. My suggestion is to unmerge those cells, delete the empty rows and re-adjust the row height 'til it looks pretty. Merged cell on worksheets are always trouble.

Try this one:

Please Login or Register  to view this content.