I'm thinking there may well be. There is a lot more casting of objects
required within C# than any VBA code i've seen, I've also noticed that there
are a number of methods that differ from the VBA equivalent. Unfortunately my
App has to be in C#. As i said, if i select the Usedrange() on the page i'm
interested in, i can select all appropriate data as a picture. This resolves
my issue just now but it does raise some concerns over the potential for
running into other issues like this.
Thanks for your help.
G
"Jon Peltier" wrote:
My code works fine even if the range to copy is scrolled off screen. I'm
using VBA, though, and I notice you're using that wacky dot net stuff. I
don't know whether there's any issue related to that.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
"GS80" wrote in message
...
In addition to my last post. It seems to be down to what is visible on the
page when the document is saved. If I open the Excel document and scroll
down
so only the 2 lowest graphs are visible, this appears to be all that is
displayed on the output. ERegardless of position, all cell data is copied
as
expected. Not sure if this is of any more help.
G
"Jon Peltier" wrote:
Did you happen to use any code for this? If so, why not paste it.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
"GS80" wrote in message
...
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