ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copy range content as picture - truncation problem (https://www.excelbanter.com/excel-programming/304777-re-copy-range-content-picture-truncation-problem.html)

Jon Peltier[_8_]

Copy range content as picture - truncation problem
 
This page in the PowerPoint FAQ has some information about truncation of
copied pictures:

http://www.rdpslides.com/pptfaq/FAQ00068.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

dwboyce wrote:

When using either the 'Camera' function or the 'CopyPicture' method, it appears that XL2000 truncates the picture such that the maximum dimension does not exceed approximately 32.2 cm.
For example, if I enter data in range("1:1") and use the 'CopyPicture' method and subsequently paste the picture, it will display about 19 columns in the picture (the column width set to 8.43 ... reducing the column width increases the number of columns but maintains the overall size of ~32.2 cm).
I have also tried the 'Chart.Export' method suggested in a previous thread with no success.

Any other suggestions?<<




All times are GMT +1. The time now is 01:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com