Okay, here is the Excel file with code. If you click on the Macro symbol in the Quick access Toolbar, it will transfer the data from Sheet 1 to Sheet 2 - the data in the specified range and all shapes. I was able to find a way so that the shapes retain their original position.
I had a lot of problem trying to solve the copy and paste methods that this code involves. Looks like there is a bug in Excel when it comes to copying and pasting shapes. But eventually the code is running consistently. So let me know if you have any problems.
In your own worksheet, change the range as needed (instead of A1:C5, enter A13:FU45 (or whatever is the range). If the source worksheet is "Sheet1" and destination worksheet is "Sheet2", then no need to make any more changes, else, you need to make those changes too.
To see the code in this sample file, press Alt+F11 and double click on "This workbook" in the Project Explorer window.
|