What I actually did (before I saw Vogn's solution) was drag a rectangle (from the drawing toolbar), highlight the excel table and paste in the rectangle.
Seems it results to exactly the same as Vogn's solution.
Actually, having tried to find the equivalent in Excel 2007 (and I can't), simply copying and pasting seems to work. In pre-2007 versions of Excel the Shift + Edit > Copy Picture was necessary (I believe) to copy charts.
This thread is resolved but I found something amusing related to this. Amusing, that is, if you're fanatical about the subject - otherwise read no further. Recently researching OLE transfers I came upon this, and looking at all the neat custom programming they did, and the superb documentation, I thought, what a neat place that must be to work for!
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.