Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Range CopyPicture()
Hi,
I'm working on an app which i need to copy a range of cells which is programatically generated using the Excel object model. I want to be able to select the output range which consists of charts and cells making up a table. I'm using the CopyPicture() method of Range which i had woring once to copy the charts and cells combination into word. Having run this again it won't pull across the charts now. The areas where these are meant to go are just blank. Has anyone experienced this before and could maybe give me some information on how to resolve this. I know it can be done as it worked once. I'm wondering if the slight adjustment made to the chart upon which the output charts are based has upset something. Copying manually seems to work but the formatting is skewed somewhat, hence the requirement of the picture to be used. Any help will be greatly appreciated. G |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Control size of chart - CopyPicture | Charts and Charting in Excel | |||
Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
CopyPicture ????? | Charts and Charting in Excel |